首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
25
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
Inanyrealmoflife-whetheracademic,social,business,orpolitical-theonlywaytosucceedistotalkeapractical,rathe
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Whileyouenjoythesunlight,itcastsyourshadowontheground.Therehasbeenadiscussionrecentlyontheissueinanewspap
Writeane-mailofabout100wordstoaforeignteacherinyourcollege,invitinghim/hertobeajudgefortheupcomingEnglish
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
主动脉瓣听诊区第二心音增强,最常见于下列何种疾病?
阅读《风波》中的几段文字,然后回答下列小题。“好香的干菜,——听到了风声了么?”赵七爷站在七斤的后面七斤嫂的对面说。“皇帝坐了龙庭了。”七斤说。七斤嫂看着七爷的脸,竭力陪笑道,“皇帝已经坐了龙庭了,几时皇恩大赦呢?”
A.K+B.Na+C.Ca2+D.Mg2+E.Zn2+细胞内液主要阳离子是
患者,男性,73岁。活动中突发右侧肢体活动不利,口角右偏,言语不清,血压220/130mmHg,头颅CT显示左侧底节区脑出血。下列说法正确的是()
按常规方法布设时,桥梁平面控制网的基本网形是( )。
如果小李考取了驾照,或者虽然没有考取驾照,但有驾驶经验,那么小李就会开车。据此,可以推出:
根据《宪法》和《组织法》规定,有权向全国人大提出宪法修正案的主体有()。
根据共同犯罪人的分工情况,可将共同犯罪人分为()。
甲、乙两人同时从A地出发,沿400米跑道同向匀速行走,25分钟后乙比甲少走了一圈.若乙行走一圈需要8分钟,则甲的速度是()米/分钟.
Whomostlikelyisthespeaker?
最新回复
(
0
)