On your Oracle 12c database, you Issue the following commands to create indexes Which
two statement are correct?
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.
Explanation:
AE