单选题You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE
单选题
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
参考解析
解析：
暂无解析
相关考题：
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 tableB、 Mapping TableC、 Clustered TableD、 Journal Table
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.
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 viewB、enable index monitoring and query the DBA_INDEXES viewC、enable index monitoring and query the V$OBJECT_USAGE viewD、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
为了监视索引的空间使用效率，可以首先分析该索引的结构，使用（）语句，然后查询INDEX_STATE视图。A、SELECT INDEX … VALIDATE STRUCTUREB、ANALYZE INDEX … VALIDATE STRUCTUREC、UPDATE INDEX … VALIDATE STRUCTURED、REBUILD INDEX … VALIDATE STRUCTURE
In which scenarios would you rebuild an index？（）A、 when you need to disable the index usageB、 when you need to change storage optionsC、 when you need to enable index monitoringD、 when you need to move the index to another tablespace
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$OBJECT_USAGE
In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）A、hash clustersB、index clustersC、partitioned tablesD、indexorganized table （IOT）
You are developing an ASP.NET MVC 2 Web application. The application contains a controller named Home Controller， which has an action named Index. The application also contains a separate area named Blog. A view within the Blog area must contain an Action Link that will link to the Index action of the Home Controller. You need to ensure that the Action Link in the Blog area links to the Index action of the HomeController. Which Action Link should you use？（）A、Html.ActionLink（"Home"， "Index"， "Home"）B、Html.ActionLink（"Home"， "Index"， "Home"， New With {.area = ""}， Nothing）C、Html.ActionLink（"Home"， "Index"， "Home"， New With {.area = "Blog"}， Nothing）D、Html.ActionLink（"Home"， "Index"， "Home"， New With {.area = "Home"}， Nothing）
You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）A、DBCC DBREINDEXB、SELECT * FROM sys.dm_db_index_physical_statsC、DBCC INDEXDEFRAGD、SELECT * FROM sys.indexes
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 populationB、sys.dm exec query statsC、sys. dm db index usage statsD、sys.dm db index physical stats
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）
You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）A、Schedule the full backups to run after the nightly index is rebuilt.B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.
Your company uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use?（）A、 DBCC CHECKTABLE B、 ALTER INDEX REORGANIZE C、 UPDATE STATISTICS D、 CREATE STATISTICS E、 DBCC SHOW_STATISTICS F、 DBCC UPDATEUSAGE
单选题You are developing an ASP.NET MVC 2 Web application. The application contains a controller named Home Controller， which has an action named Index. The application also contains a separate area named Blog. A view within the Blog area must contain an Action Link that will link to the Index action of the Home Controller. You need to ensure that the Action Link in the Blog area links to the Index action of the HomeController. Which Action Link should you use？（）AHtml.ActionLink（Home， Index， Home）BHtml.ActionLink（Home， Index， Home， New With {.area = }， Nothing）CHtml.ActionLink（Home， Index， Home， New With {.area = Blog}， Nothing）DHtml.ActionLink（Home， Index， Home， New With {.area = Home}， Nothing）
单选题At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A Start the database in OPEN mode， and create a new index tablespace.B Start the database in OPEN mode， and drop the lost index tablespace from the database.CStart the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
单选题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？（）AHtml.ActionLink（Home， Index， Home）BHtml.ActionLink（Home， Index， Home， new {area = }， null）CHtml.ActionLink（Home， Index， Home， new {area = Blog}， null）DHtml.ActionLink（Home， Index， Home， new {area = Home}， null）
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A The PRIMARY KEY is created along with a new index.B The PRIMARY KEY is created and it would use an existing unique index.C The PRIMARY KEY would be created in a disabled state because it is using an existing index.D The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
单选题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.
单选题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？（）Aenable index monitoring and query the DBA_OBJECTS viewBenable index monitoring and query the DBA_INDEXES viewCenable index monitoring and query the V$OBJECT_USAGE viewDenable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
单选题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 tableB Mapping TableC Clustered TableD Journal Table
单选题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？（）Asys.dm fts index populationBsys.dm exec query statsCsys. dm db index usage statsDsys.dm db index physical stats
单选题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$OBJECT_USAGE
单选题You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）ADBCC DBREINDEXBSELECT * FROM sys.dm_db_index_physical_statsCDBCC INDEXDEFRAGDSELECT * FROM sys.indexes
单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE 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?（）Adisabling the indexBmaking the index invisibleCmaking the index unusableDusing the MONITORING USAGE clause for the index
多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
单选题You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）ASchedule the full backups to run after the nightly index is rebuilt.BSchedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.CSchedule an additional transaction log backup to run after the nightly index is rebuilt.DSchedule a marker to be added to the transaction log before the nightly index is rebuilt.