Oracle
1Z0-117 · Question #66
1Z0-117 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
Examine the exhibit to view the query and its execution plan. Identify the two correct interpretations that can be made from the execution plan.
Exhibit
Options
- AThe DEPT table is driving table and the EMP table join is the driven table.
- BRows from the DEPT table are first hashed by the join key into memory and then joined to the EMP table
- CThe EMP table is the driving table and the DEPT table us the driven table.
- DThe rows from the DEPT table are sorted first by the join key and then hashed into memory.
- ERows from both the tables are sorted by the join key, but only rows from the DEPT table are hashed into
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.