首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
36
问题
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
微软认证
相关试题推荐
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
随机试题
曝光时,x线管和探测器不动,而床带动患者动,称其
Internet中使用的最主要的协议是()
未分化生殖腺向睾丸分化的决定因素是()
乳糜尿形成的原因是
家长询问小儿囟门闭合的年龄是
一般认为,一个职业运动员在45岁时和他在30岁时相比,运动水平和耐力都会明显降低,但是在已退役与正在服役的职业足球运动员中举行的一场马拉松比赛结果却是:45岁的退役足球运动员和30岁的正在服役的运动员在比赛中的成绩没有什么差别。据此,认为一个职业球员到了4
A、 B、 C、 D、 A若X→→V,而Z=Φ,则称X→→Y为平凡的多值依赖。若X→→Y在R(U)上成立,且Y’∈Y,我们不可以断言X→→Y’成立。设R是属性集U上的一个关系模式,X、Y是U的
CannedFoods:ConvenienceandNutritionMeetingyourfamily’snutritionalneedsmayseemdifficultconsideringtoday’sbusyl
Yetthedifferenceintoneandlanguagemuststrikeus,sosoonasitisphilosophythatspeaks:thatchangeshouldremindusth
TheUnitedStatesiswellknownforitsnetworkofmajorhighwaysdesignedtohelpadrivergetfromoneplacetoanotherinthe
最新回复
(
0
)