多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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、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,E
答案解析:
进入题库查看解析

微信扫一扫手机做题