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

Oracle认证考试

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

On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?()

  • A、Only the ORD_CUSTOMER_IX1 index created.
  • B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
  • C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
  • D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
  • E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.
  • F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
正确答案:B,F
答案解析:
进入题库查看解析

微信扫一扫手机做题