首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
62
问题
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
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Guest账户和Administrator账户一样是由系统建立的,不能被禁用。
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
量取背部穴位,一般以肩胛骨下角作为标志,此处约与以下哪个胸椎相平
编制计量检定规程的一般原则是什么?
在有毒有害气体泄漏时,事故指挥中心应该设在()。应急演习根据演习的基本内容不同可以分为()。
措施项目清单位可调整清单是指( )。
下列各项中,属于各单位加强现金和银行存款管理的重要账簿是()。
银行业从业人员在办理资金交易业务中,不得有下列行为()。
下列关于作业成本法的说法,正确的有()。
《学记》提出课内和课外要相结合,且课外要有丰富多彩的生活。下列说法与这一观点相同的是()。
某家饭店中,一桌人边用餐边谈生意。其中,一个人是哈尔滨人,两个人是北方人,一个人是广东人。两个人只做电脑生意,三个人只做服装生意。如果以上介绍涉及餐桌上所有的人,那么这一桌最少可能是几个人?最多可能是几个人?
Inthedesignofmedicalexperiments,theneedfor(i)________assignmentoftreatmentstopatientsmustbe(ii)________thedif
最新回复
(
0
)