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.

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.