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