首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
31
问题
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
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Writeanessayof160-200wordsbasedonthefollowingdrawings.Inyouressay,youshould1)describethedrawingsbriefly,
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
随机试题
诊断早期妊娠需测定的血或尿中的激素是
水疝相当于西医学的什么病
原发性血小板增多见于( )。
【背景资料】某城市桥梁工程由某路桥工程公司承担施工任务。该路桥工程公司在预应力筋的施工过程中,通过计算确定了下料长度,并采用先张法对预应力筋进行张拉,并对施加预应力所用的机具设备及仪表设置专人使用管理,并制订定期维护和校验制度。在对大体积混凝土墩台基
关于银行卡账户及交易管理要求的下列表述中,不正确的是()。
下列关于农村金融机构的说法,正确的有()。
(2016年真题)孟老师近期工作比较消极,漠视学生的存在,对学生态度麻木,缺乏应有的尊重。依据职业倦怠的特征,孟老师的这些表现属于()。
NewYorkandLondonmayruletheroost,butotherfinancialhubsinAmericaandEuropehavemanagedtocarveoutusefulspecial
牙周袋位于牙槽嵴顶下方,与牙槽骨垂直吸收有关者为()。
Inthepast,oneofthebiggestdisadvantagesofmachineshasbeentheirinabilitytoworkonamicro-scale.Forexample,doctor
最新回复
(
0
)