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运算符一起使用。