Which two statements are true regarding operators used with subqueries? (Choose two.)
A.
The NOT IN operator is equivalent to IS NULL.
B.
The <ANY operator means less than the maximum.
C.
=ANY and =ALL operators have the same functionality.
D.
The IN operator cannot be used in single-row subqueries.
E.
The NOT operator can be used with IN, ANY and ALL operators.
E is not entirely right…
!= ANY will work.
But NOT ALL won’t work.
SELECT employee_id, salary
FROM employees
WHERE NOT (salary > ALL (2000, 3000, 4000));
NOT operator(!)
Old documentation but still valid. (I could not find quickly newer):
http://docs.oracle.com/html/A95915_01/sqopr.htm#i1004774
ALL Compares a value with every value in a list or returned by a query. Must be preceded by =, !=, >, <, =. Evaluates to TRUE if the query returns no rows.
ANY/ SOME Compares a value to each value in a list or returned by a query. Must be preceded by =, !=, >, <, =. Evaluates to FALSE if the query returns no rows.
Correct answer is BE