1z0-071 Oracle Database 12c SQL 第24题 多行子查询

Q24. Which two statements are true regarding multiple-row subqueries? (Choose two.)
A. They can contain group functions.
B. They always contain a subquery within a subquery.
C. They use the < ALL operator to imply less than the maximum.
D. They can be used to retrieve multiple rows from a single table only.
E. They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.

Correct Answer: AE

A.它们可以包含组函数

B.它们总是在子查询中包含子查询

C.他们使用<ALL运算符暗示小于最大值

D.它们可用于仅从单个表中检索多行

E.如果NULL很可能是子查询结果的一部分，则它们不应与主查询中的NOT IN运算符一起使用。