Oracle
1Z0-147 · Question #29
Which statement about multiple column subqueries is true?
The correct answer is B. A non-pairwise comparison produces a cross product. See the full explanation below for the reasoning.
Question
Which statement about multiple column subqueries is true?
Options
- AA pairwise comparison produces a cross product.
- BA non-pairwise comparison produces a cross product.
- CIn a pairwise subquery, the values returned from the subquery are compared individually to the values in the outer query.
- DIn a non-pairwise subquery, the values returned from the subquery are compared as a group to the values in the outer query.
How the community answered
(14 responses)- A7% (1)
- B71% (10)
- C14% (2)
- D7% (1)
Community Discussion
No community discussion yet for this question.