Oracle
1Z0-117 · Question #72
1Z0-117 Question #72: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.
Question
Examine the Exhibit to view the structure of and indexes for the EMPLOYEES and DEPARTMENTS tables: EXAMINE the SQL statement and its execution plan: Which two statements are correct regarding the execution plan?
Exhibits
Options
- AStep 2 is performing nested operation on JOB_ID column of the JOBS table, which is the driven table
- BIn step 2 for every row returned by the JOBS table matching rows from the EMPLOYEES table are accessed.
- CStep 1 is performing nested loop operation on the DEPARTMENT_ID column of the DEPARTMENTS
- DThe performance of the query can be improved by creating bitmap index on the JOB_ID column of the
- EThe performance of the query can be improved by creating bitmapped index on the DEPARTMENT_ID
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.