Oracle
1Z0-047 · Question #56
Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)
The correct answer is A. The outer query stops evaluating the result set of the inner query when the first value is found. C. It is used to test whether the values retrieved by the outer query exist in the result set of the inner query. See the full explanation below for the reasoning.
Question
Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)
Options
- AThe outer query stops evaluating the result set of the inner query when the first value is found.
- BIt is used to test whether the values retrieved by the inner query exist in the result of the outer query.
- CIt is used to test whether the values retrieved by the outer query exist in the result set of the inner query.
- DThe outer query continues evaluating the result set of the inner query until all the values in the result
How the community answered
(62 responses)- A71% (44)
- B11% (7)
- D18% (11)
Community Discussion
No community discussion yet for this question.