Which statement is true regarding subqueries?
A.
The LIKE operator cannot be used with single- row subqueries.
B.
The NOT IN operator is equivalent to IS NULL with single- row subqueries.
C.
=ANY and =ALL operators have the same functionality in multiple- row subqueries.
D.
The NOT operator can be used with IN, ANY, and ALL operators in multiple- row subqueries.
Explanation:
Using the ANY Operator in Multiple-Row Subqueries
The ANY operator (and its synonym, the SOME operator) compares a value to each value returned
by a subquery.
<ANY means less than the maximum.
>ANY means more than the minimum.
=ANY is equivalent to IN
Using the ALL Operator in Multiple-Row Subqueries
The ALL operator compares a value to every value returned by a subquery.
>ALL means more than the maximum and
<ALL means less than the minimum.
The NOT operator can be used with IN, ANY, and ALL operators.