Oracle
1Z0-117 · Question #42
1Z0-117 Question #42: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
Question
Examine Exhibit 1 to view the query and its execution plan. Examine Exhibit 2 to view the structure and indexes for the EMPLOYEES and DEPARTMENTS tables. Examine Exhibit 3 to view the initialization parameters for the instance. Why is sort-merge join chosen as the access method?
Exhibits
Options
- ABecause the OPTIMIZER_MODE parameter is set to ALL_ROWS.
- BBecause of an inequality condition.
- CBecause the data is not sorted in the LAST_NAME column of the EMPLOYEES table
- DBecause of the LIKE operator used in the query to filter out records
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.