Which three statements about subqueries are true? ()
A:A main query can have more than one subquery.
B:A subquery can have more than one main query.
C:The subquery and main query must retrieve data from the same table.
D:The subquery and main query can retrieve data from different tables.
E:Only one column or expression can be compared between the subquery and main query.
F:Multiple columns or expression can be compared between the subquery and main query.
出自:Oracle认证