On your Oracle 12c database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true? (Choose two.)
A. The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.
B. Both the indexes are created: however, only ORD_CUSTOMER_IX2 index is visible.
C. Only the ORD_CUSTOMER_IX1 index is created.
D. Only the ORD_CUSTOMER_IX2 index is created.
E. Both the indexes are updated when a new row is inserted, updated, or deleted in the ORDERS table.
|
Download Printable PDF. VALID exam to help you PASS. |
 |