单选题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

考题 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？（）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）

查看答案

考题单选题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.C Start 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？（）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）

查看答案

考题单选题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？（）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 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？（）A sys.dm fts index populationB sys.dm exec query statsC sys. dm db index usage statsD sys.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？（）A DBCC DBREINDEXB SELECT * FROM sys.dm_db_index_physical_statsC DBCC INDEXDEFRAGD SELECT * 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?（）A disabling the indexB making the index invisibleC making the index unusableD using 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？（）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.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：