Oracle Database SQL — Question 117

Which three statements are true about multiple row subqueries? (Choose three.)

Answer options

• A. Two or more values are always returned from the subquery.
• B. They can contain HAVING clauses.
• C. They can contain GROUP BY clauses.
• D. They can return multiple columns.
• E. They cannot contain a subquery.

Correct answer: B, C, D

Explanation

The correct answers are B, C, and D because multiple row subqueries can indeed include HAVING and GROUP BY clauses, and they can return multiple columns. Option A is incorrect because while multiple values can be returned, it is not a requirement that two or more values are always returned. Option E is wrong because subqueries can exist within multiple row subqueries.