单选题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？（）AINDEX_STATSBDBA_INDEXESCDBA_IND_COLUMNSDV$OBJECT_US

第1题：

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

第2题：

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

第3题：

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_STATS
• B、 DBA_INDEXES
• C、 DBA_IND_COLUMNS
• D、 V$OBJECT_USAGE

第4题：

You manage a SQL Server 2005 database that contains a table with many indexes.  You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）

• A、sys.dm fts index population
• B、sys.dm exec query stats
• C、sys. dm db index usage stats
• D、sys.dm db index physical stats

第5题：

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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; 

第15题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed， a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions， this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless， the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However， the application that executes the query should not be changed. In addition， the effect on end users should be cut to the least.  Which action should be performed to finish the task？（）

• A、To finish the task， the index should be built by utilizing a FILLFACTOR of 10 percent.
• B、To finish the task， the index should be recreated to have all of the columns in the table included.
• C、To finish the task， an indexed view of the Orders table should be viewed.
• D、To finish the task， the statistics should be updated on the index.

第16题：

You are developing an ASP.NET MVC 2 Web application. The application contains a controller named HomeController， which has an action named Index. The application also contains a separate area named Blog. A view within the Blog area must contain an ActionLink that will link to the Index action of the HomeController. You need to ensure that the ActionLink in the Blog area links to the Index action of the HomeController. Which ActionLink should you use？（）

• A、Html.ActionLink（"Home"， "Index"， "Home"）
• B、Html.ActionLink（"Home"， "Index"， "Home"， new {area = ""}， null）
• C、Html.ActionLink（"Home"， "Index"， "Home"， new {area = "Blog"}， null）
• D、Html.ActionLink（"Home"， "Index"， "Home"， new {area = "Home"}， null）

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：