Which two statements are true regarding the USING and ON clauses in table joins?()
A:Both USING and ON clauses can be used for equijoins and nonequijoins 
B:Amaximum of one pair of columns can be joined between two tables using the ON clause 
C:The ON clause can be used to join tables on columns that have different names but compatible data types 
D:The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 
出自:Oracle认证