Which three statements are true about the execution of this query?

View the code sequence:


Which three statements are true about the execution of this query?
A. The optimizer uses an index join as an access path.
B. The optimizer uses a B* tree access path for the EMPLOYEES table.
C. The optimizer uses a bitmap access path for the EMPLOYEES table.
D. The optimizer performs bitmap conversion fromrow IDs.
E. The optimizer performs bitmap conversion to row IDs of the combined maps.
F. The optimizer performs bitmap conversion from the row IDs of the combined maps.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.