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 statement are correct?()
A. oth 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. oth the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
查看答案
该试题由用户141****32提供
查看答案人数:39362
如遇到问题请
联系客服
正确答案
该试题由用户141****32提供
查看答案人数:39363
如遇到问题请联系客服