Which statement is true regarding subqueries?（）
- AThe LIKE operator cannot be used with single-row subqueries
- BThe 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
- DThe NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries&e