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

The correct answer is A. The ORDER BY clause can be used in the subquery. B. A subquery can be used in the FROM clause of a SELECT statement. C. If the subquery returns NULL, the main query may still return result rows. See the full explanation below for the reasoning.

Question

Options

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

How the community answered

(33 responses)

A
76% (25)
D
9% (3)
E
15% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice