可学答题网 > 问答 > OCP 11G认证考试题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

An index called ORD_CUSTNAME_IX has b


An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?()

  • A disabling the index
  • B making the index invisible
  • C making the index unusable
  • D using the MONITORING USAGE clause for the index
参考答案
参考解析:
分类:OCP 11G认证考试题库
相关推荐

1、A customer called an

A customer called and indicated that their p690 system did not come with any inst...

2、A marine sextant has the index arm set

A marine sextant has the index arm set at zero and the reflected image of the horizon forms a continuous line with the actual image. When t...

3、User Mary has a view called EMP_DEPT_L

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege t...

4、Mary has a view called EMP_DEPT_LOC_V

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege ...

5、An organization calledQ

An organization called contoso.com has Exchange Server 2010.@contoso.com e-mail address suffix. Ano...

6、()has been called the “cradle of Ameri

()has been called the “cradle of American Liberty”.APhiladelphiaBPlymouthCBosto