Oracle
1Z0-071 · Question #236
Which two statements are true regarding operators used with subqueries (Choose two.)
The correct answer is B. The <ANY operator means less than the maximum. E. The NOT operator can be used with IN, ANY and ALL operators. See the full explanation below for the reasoning.
Question
Which two statements are true regarding operators used with subqueries (Choose two.)
Options
- AThe NOT IN operator is equivalent to IS NULL.
- BThe <ANY operator means less than the maximum.
- C=ANY and =ALL operators have the same functionality.
- DThe IN operator cannot be used in single-row subqueries.
- EThe NOT operator can be used with IN, ANY and ALL operators.
How the community answered
(35 responses)- A6% (2)
- B80% (28)
- C11% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.