2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. The server contains a database that has the torn page detection databas

You are the administrator of a SQL Server 2000 computer. The server contains a database that has the torn page detection databas

admin2009-05-19  27
问题 You are the administrator of a SQL Server 2000 computer. The server contains a database that has the torn page detection database option enabled. Backups of the database are made daily.

The server loses power for one minute. When power is restored, torn pages are detected. You notice in SQL Server Enterprise Manager that the database is marked suspect.
You need to correct the problem. What should you do?
选项 A、Execute the DBCC CHECKDB statement, and then specify the PHYSICAL_ONLY option.
B、Execute the DBCC CHECKDB statement, and then specify the REPAIR_REBUILD option.
C、Execute the sp_resetstatus stored procedure.
D、Restore the suspect database from backups.
答案D
解析 Explanation: In SQL Server 2000, the TORN_PAGE_DETECTION option is a database recovery option that allows SQL Server to detect incomplete I/O operations caused by power failures or other system outages. When this option is set to ON, which it is by default, it causes a bit to be reversed for each 512-byte sector in an 8KB database page when the page is written to disk.

If a bit is in the wrong state when the page is later read by SQL Server, the page was written incorrectly and a torn page is detected. Using batterybacked disk caches can ensure that data is successfully written to disk or not written at all. If the torn page is detected the database is marked suspect. When this occurs, the database backup should be restored, and any transaction log backups applied, because the database is physically inconsistent.

Incorrect Answers:
A: The DBCC CHECKDB statement checks the allocation and structural integrity of all the objects in the specified database. This statement can specify the PHYSICAL_ONLY option, which limits the checking to the integrity of the physical structure of the page and record headers, and to the consistency between the pages’ object ID and index ID and the allocation structures.

This check also detects torn pages and common hardware failures that can compromise a user’s data. However, the PHYSICAL_ONLY option is not allowed with any of the DBCC CHECKDB statement’s repair options.

B: The DBCC CHECKDB statement checks the allocation and structural integrity of all the objects in the specified database. This statement can specify repair options. It can specify the REBUILD_FAST option, which performs minor, nontime-consuming repair actions such as repairing extra keys in nonclustered indexes and can be done quickly and without risk of data loss; and it can specify the REPAIR_REBUILD option, which performs all repairs that can done by REPAIR_FAST and as well as includes time-consuming repairs such as index rebuilding. These repairs can also be done without risk of data loss.

C: The sp_resetstatus stored procedure is not a recovery option. It turns off the suspect flag on a database by updating the mode and status columns of the named database in sysdatabases. Because this procedure modifies the system tables, the system administrator must enable updates to the system tables before creating this procedure and the SQL Server 2000 must shut down and restate immediately after executing this procedure.
转载请注明原文地址:https://kaotiyun.com/show/PuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)