OCP-1Z0-051-2015-5题

QUESTION NO: 5
Which three statements are true regarding sub queries? (Choose three.)
A. Multiple columns or expressions can be compared between the main query and sub query
B. Main query and sub query can get data from different tables
C. Sub queries can contain GROUP BY and ORDER BY clauses
D. Main query and sub query must get data from the same tables
E. Sub queries can contain ORDER BY but not the GROUP BY clause
F. Only one column or expression can be compared between the main query and subqeury
Answer: A,B,C

Explanation:

A,主查询与子查询之间可以比较多个列或多个表达式.

B,主查询和子查询能从不同的表里获取数据

C,子查询可以包含GROUP BY和ORDER BY子句

D,主查询和子查询必须从同一个表获取数据,错误，可以从不同表获取数据

E,子查询能包含ORDER BY 子句，但是不能包含GROUP BY子句,错误，可以包含GROUP BY子句

F,主查询与子查询之间只能比较一个列或一个表达式，错误，可以比较多行，使用any，all等