Which two statements about subqueries are true? （）
A:A single row subquery can retrieve data from only one table.
B:A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
C:A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.
D:A single row subquery can retrieve data from more than one table.
E:A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F:A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
出自：Oracle认证