On your Oracle 12c database, you Issue the followi...
多选题

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?()

发布日期:2020-04-10

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.

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定