Oracle Database 12c: Installation and Administration — Question 42

On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statements are correct? (Choose two.)

Answer options

• A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• 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.

Correct answer: A, E

Explanation

The correct answer A states that both indexes are created, but ORD_CUSTOMER_IX1 is invisible, which is accurate. Option E is also correct because both indexes will be updated with any changes to the orders table. Options B, C, and D are incorrect because the optimizer does not ignore the invisible index, and both indexes are indeed created.