Which statement is true regarding sub queries?
A.
The NOT IN operator is equivalent to IS NULL with single- row subqueries.
B.
=ANY and =ALL operators have the same functionality in multiple- row subqueries.
C.
The LIKE operator cannot be used with single- row subqueries.
D.
The NOT operator can be used with IN, ANY, and ALL operators in multiplerowsubqueries.
A is incorrect
B is incorrect
C is incorrect
D is incorrect
There is no correct answer listed.
The NOT operator can be used with IN, but it cannot be used with the ANY or ALL operators.
You can use NOT with IN but ANY or ALL I am unsure about
This is correct.. See..
http://www.aiotestking.com/oracle/which-two-statements-are-true-regarding-operators-used-with-subqueries/