试题详情
- 多项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- Given a
- Which two statements
- Which is
- ClicktheExhibitbutto
- 写出ORACLE的四种文件。（从物理存储
- You need to display
- Evaluate the&e
- You find
- One of t
- Given： Which c
- Which options must y
- What does̳
- Which of
- Which of the followi
- You have altered a
- In which case would
- Which DBMS_SCHEDULER
- You define a multipl
- Which two̳
- What recommend