1Z0-117 practice - PrepKeys

Q3 Single choice

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?

A
The query uses an index skip scan on the EMP_EMP_ID_PK index to fetch the rows.
B
The query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values are evaluated using an index range scan on the EMP_EMP_ID_PK index.
C
The query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values are evaluated using a fast full index scan on the EMP_EMP_ID_PK index.
D
The query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values are evaluated using an index unique scan on the EMP_EMP_ID_PK index.
E
The query uses a fast full index scan on the EMP_EMP_ID_PK index fetch the rows.