OCP-1Z0-051 第135题 子查询注意事项

一、原题

Which three statements are true regarding subqueries? (Choose three.)
A. Subqueries can contain GROUP BY and ORDER BY clauses.
B. Main query and subquery can get data from different tables.
C. Main query and subquery must get data from the same tables.
D. Subqueries can contain ORDER BY but not the GROUP BY clause.
E. Only one column or expression can be compared between the main query and subquery.
F. Multiple columns or expressions can be compared between the main query and subquery.

答案：ABF

二、题目翻译

关于子查询哪三个语句是正确的？(选择3项)
A.子查询可以包含GROUP BY和ORDER BY子句。
B.主查询和子查询能从不同的表里获取数据。
C.主查询和子查询必须从同一个表获取数据。
D.子查询能包含ORDER BY 子句，但是不能包含GROUP BY子句。
E.主查询与子查询之间只能比较一个列或一个表达式。
F.主查询与子查询之间可以比较多个列或多个表达式。