Which two statements are true regarding multiple-row subqueries? (Choose two.)
A.
They can contain group functions.
B.
They always contain a subquery within a subquery.
C.
They use the < ALL operator to imply less than the maximum.
D.
They can be used to retrieve multiple rows from a single table only.
E.
They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.
i think C is correct. So why is anwer E correct?
why is E correct? Not In with result NULL
The null value affects the outcome of the NOT IN operator.
< ANY is less than maximum
<ANY is less than minimum
eg:5<ALL(10,30,50)
ALL is equal to AND operator
Correct answer is AE