1Z0-117 Web TestEngine demo

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?

Select all that apply.

• A

  Step 2 is performing nested operation on JOB_ID column of the JOBS table, which is the driven table and the EMPLOYEES table is the driven table.

• B

  In step 2 for every row returned by the JOBS table matching rows from the EMPLOYEES table are accessed.

• C

  Step 1 is performing nested loop operation on the DEPARTMENT_ID column of the DEPARTMENTS table, which is the driven table and results returned by step 2 in the driving resultset.

• D

  The performance of the query can be improved by creating bitmap index on the JOB_ID column of the EMPLOYEES table.

• E

  The performance of the query can be improved by creating bitmapped index on the DEPARTMENT_ID column of the EMPLOYEES table.