首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
admin
2009-05-19
10
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
下列哪种用药方法是错误的
需立即进行剖宫产术的征象是出现()。
在关系营销的特征中,信息的及时反馈可使关系营销具有动态的应变性,有利于挖掘新的市场机会。信息反馈的及时性表现为:关系营销应该具备一个()系统,以连接关系双方。
试述政府在社会主义市场经济条件下的经济职能。
典型的食品感官检验方法中定性分析包括()
少数人注射青霉素后出现胸闷、气急和呼吸困难等过敏(超敏)反应症状,严重者发生休克。以下有关叙述,正确的是:
2π
EveryoneknowshowtogettoCarnegieHall:practice,practice,practice.Butwhatabouthowtogetintothenation’smosthonor
继承是一种共享机制,指子类共享父类/超类的结构和方法。继承(包括多重继承和单重继承)使类的结构呈现(53)的结构关系。
WuhanlearnersofEnglishtendtopronounce"night"as"light".Thisshows______.
最新回复
(
0
)