Which three statements are true regarding single row subqueries?

The correct answer is C. They can be used in the where clause. D. A SQL statement may have multiple single row subquery blocks. F. They can be used in the having clause. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

Options

AThey must be placed on the right side of the comparison operator or condition.
BThey must be placed on the left side of the comparison operator or condition.
CThey can be used in the where clause.
DA SQL statement may have multiple single row subquery blocks.
EThey must return a row to prevent errors in the SQL statement.
FThey can be used in the having clause.

How the community answered

(26 responses)

A
12% (3)
B
4% (1)
C
77% (20)
E
8% (2)

Topics

#single row subqueries#WHERE clause#HAVING clause#subquery blocks

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice