Home » Oracle » 1z0-051 » Which statement is true regarding sub queries?
Which statement is true regarding sub queries?
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.
Correct Answer: D
Explanation/Reference:
Explanation:
Using the ANY Operator in Multiple-Row Subqueries
The ANY operator (and its synonym, the SOME operator) compares a value to each value returned by a subquery.
<ANY means less than the maximum.
>ANY means more than the minimum.
=ANY is equivalent to IN
Using the ALL Operator in Multiple-Row Subqueries
The ALL operator compares a value to every value returned by a subquery.
>ALL means more than the maximum and <ALL means less than the minimum.
The NOT operator can be used with IN, ANY, and ALL operators.
Download Printable PDF. VALID exam to help you PASS.
|
|