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

The correct answer is A. The ORDER BY Clause can be used in a subquery. B. A subquery can be used in the FROM clause of a SELECT statement. D. A subquery can be placed in a WHERE clause, a GROUP BY clause, or a HAVING clause. See the full explanation below for the reasoning.

Question

Options

AThe ORDER BY Clause can be used in a subquery.
BA subquery can be used in the FROM clause of a SELECT statement.
CIf a subquery returns NULL, the main query may still return rows.
DA subquery can be placed in a WHERE clause, a GROUP BY clause, or a HAVING clause.
ELogical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a

How the community answered

(17 responses)

A
71% (12)
C
18% (3)
E
12% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice