Oracle Database SQL — Question 203

Which three statements are true regarding single row subqueries? (Choose three.)

Answer options

• A. They must be placed on the left side of the comparison operator or condition.
• B. They must be placed on the right side of the comparison operator or condition.
• C. They must return a row to prevent errors in the SQL statement.
• D. A SQL statement may have multiple single row subquery blocks.
• E. They can be used in the HAVING clause.
• F. They can be used in the WHERE clause.

Correct answer: D, E, F

Explanation

The correct answers (D, E, F) highlight that a SQL statement can indeed contain multiple single row subquery blocks, and that these subqueries can be utilized in both the HAVING and WHERE clauses. Options A, B, and C are incorrect because single row subqueries can be placed on either side of a comparison operator, and they do not necessarily need to return a row to avoid errors.