On your Oracle 12c database, you Issue the following commands to create indexes Which
two statement are correct?
A.
Only the ORD_CUSTOMER_IX2 index is created.
B.
Both the indexes are updated when a new row is inserted, updated, or deleted In the
orders table.
C.
Only the ORD_CUSTOMER_IX1 index is created.
D.
The optimizer evaluates index access from both the Indexes before deciding on which
index to use for query execution plan.
E.
Both the indexes are created; however, only the ORD_COSTOMER index is visible.
Explanation:
B,E