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认证