首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the database administrator of a SQL Server 2000 computer. The server contains your company’s Accounts database. Hundreds
You are the database administrator of a SQL Server 2000 computer. The server contains your company’s Accounts database. Hundreds
admin
2009-05-19
63
问题
You are the database administrator of a SQL Server 2000 computer. The server contains your company’s Accounts database. Hundreds of users access the database each day.
Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
What should you do?
选项
A、Enable the torn page detection database option for each database.
B、Disable write caching on all disk controllers.
C、Ensure that write caching disk controllers have battery backups.
D、Create a database maintenance plan to check database integrity and make repairs each night.
答案
C
解析
Explanation: The scenario states that power interruptions have occurred in the past. By buying a battery backup solution for the disk controllers the power interruption problem would be prevented.
Incorrect Answers:
A: Torn page detection is a reactive solution which would slow down performance since restores would have to be made. It would better to use a preventive solution.
Note: Torn page detection: If a torn page is detected, the database must be restored from backup because it will be physically inconsistent.
B: Caching is very import for performance. Disabling write-caching would be a bad idea.
D: Repairing the database every night is not a good solution. Database errors cannot be accepted. It is better to prevent the problem instead of trying to fix it after it has happened.
转载请注明原文地址:https://kaotiyun.com/show/FuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Asthemini-blogisbecomingincreasinglypopularamongnetizens,italsobecomescommontocreaterumors.Youaresupposedtow
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
国际企业在初始阶段的管理组织可采取的结构形式是()
A.WashingtonwenttostudybridgesB.toexpressherthanksC.WashingtontookoverthejobD.tobuildthebridgeE.Emilybeg
患者张某,男性,40岁。发热恶寒,咳嗽,咳白黏痰,痰量由少渐多,胸痛,咳时尤甚,呼吸不利,口干,苔薄黄,脉浮滑数。其治法为
被称为面侧深区钥匙的是
患者车撞伤4小时,右上腹痛,查血压80/60mmHg,脉搏120次/分,右肋见皮擦伤,右上腹压痛明显,全腹轻度肌紧张,移动性浊音阳性,肠音弱,尿色正常。应首先进行下列哪项检查()
下列关于定额计价方法与工程量清单计价方法的阐述不正确的是()。
在知识的提取阶段,个体应用所学知识来解决实际问题,使所学知识产生广泛迁移。()
设(X,y)服从二维正态分布,其联合概率密度为,则()
A、cheersB、medalsC、thanksA棒球运动员之所以这样做是为了“show-off”,所以他“一只手”打球,并且“轻而易举地”完成一个看上去比较高难度的动作,目的是为了赢得观念的“喝彩”。
Britainwasawealthycountry.Therewereafewveryrichpeoplewhoreceivedmoneyfromlandor【B1】______,anddidnotneedt
最新回复
(
0
)