Oracle
1Z0-117 · Question #59
1Z0-117 Question #59: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #59. The question stem and answer options stay visible for context.
Question
Examine the Exhibit1 to view the structure of an indexes for the EMPLOYEES table. Examine the query: SQL> SELECT * FROM employees WHERE employees_id IN (7876, 7900, 7902); EMPLOYEE_ID is a primary key in the EMPLOYEES table that has 50000 rows. Which statement is true regarding the execution of the query?
Exhibit
Options
- AThe query uses an index skip scan on the EMP_EMP_ID_PK index to fetch the rows.
- BThe query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values
- CThe query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values
- DThe query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values
- EThe query uses a fast full index scan on the EMP_EMP_ID_PK index fetch the rows.
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.