Oracle
1Z0-117 · Question #90
Refer to the Exhibit. Execution plan: What must be the correct order of steps that the optimizer executes based on the ID column the execution plan?
The correct answer is D. 4, 5, 3, 7, 6. See the full explanation below for the reasoning.
Question
Refer to the Exhibit. Execution plan:
What must be the correct order of steps that the optimizer executes based on the ID column the execution plan?
Exhibits
Options
- A3, 5, 4, 6, 7
- B3, 5, 4, 7, 6
- C3, 4, 5, 7, 6
- D4, 5, 3, 7, 6
How the community answered
(53 responses)- A13% (7)
- B8% (4)
- C2% (1)
- D77% (41)
Community Discussion
No community discussion yet for this question.