试题详情
- 多项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- In which scenario wo
- 如何显示今天是星期几（周一到周日，分别用
- Given: Whichtwoco
- Which RMANQ
- You work
- When you
- Your database
- 下列哪一项是Oracle数据库中最小的存
- You want to perform
- Examine the followi
- Given： Which s
- In your
- Consider the&e
- Examine the followi
- 使用（），可以将某个SQL语句的执行依赖
- You own a table cal
- The EMPLOYEES&
- Which two̳
- You received&en
- At 5：30 P