IBM
C2090-312 · Question #98
If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?
The correct answer is C. One sort in the plan step will accomplish two tasks. See the full explanation below for the reasoning.
Question
If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?
Options
- AThe next sort step will perform two sorts.
- BThere are multiple sorts in the plan step.
- COne sort in the plan step will accomplish two tasks.
- DTwo sorts are performed on the new table of a star join.
How the community answered
(41 responses)- A5% (2)
- B7% (3)
- C73% (30)
- D15% (6)
Community Discussion
No community discussion yet for this question.