Which statement is true regarding sub queries?

Which statement is true regarding sub queries?

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.