You issued the following statement to monitor the usage of the index：        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE；   Which view will you query to ensure that the index is being monitored？（）  A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJ

第1题：

第2题：

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（） 

• A、 Index-organized table
• B、 Mapping Table
• C、 Clustered Table
• D、 Journal Table

第3题：

正确答案：C

第4题：

You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（） 

• A、 INDEX_STATS
• B、 DBA_INDEXES
• C、 DBA_IND_COLUMNS
• D、 V$OBJECT_USAGE

第5题：

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

第6题：

第7题：

You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）

• A、 Rebuild the index.
• B、 Coalesce the index.
• C、 Drop and re-create the index in the new tablespace.
• D、 Relocate the index using the ALTER INDEX...MOVE statement.

第8题：

第9题：

You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）

• A、enable index monitoring and query the DBA_OBJECTS view
• B、enable index monitoring and query the DBA_INDEXES view
• C、enable index monitoring and query the V$OBJECT_USAGE view
• D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

第10题：

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

• A、ALTER TABLE employees monitor index employee_idx_fk; 
• B、ALTER INDEX employee_idx_fk monitoring on; 
• C、ALTER TABLE employees monitor all indexes; 
• D、ALTER INDEX employee_idx_fk monitoring usage;