Oracle
1Z0-117 · Question #94
1Z0-117 Question #94: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #94. The question stem and answer options stay visible for context.
Question
View the exhibit and examine the query and its execution plan from the PLAN_TABLE, Which statement is true about the execution?
Exhibit
Options
- AThe row with the ID column having the value 0 is the first step execution plan.
- BRows are fetched from the indexes on the PRODUCTS table and from the SALES table using full table
- CRows are fetched from the SALES table, and then a hash join operator joins with rows fetched from
- DAll the partitions of the SALES table are read in parallel.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.