首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database
You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database
admin
2009-05-19
31
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database of old records and perform a full backup. The database now uses 4 GB of space. The database files are configured as shown in the Acct Properties exhibit.
The server has two hard disks that are configured as shown in the Server Configuration exhibit.
The 3 GB transaction log file for the Acct database is stored on drive C. You need to make room for a new database that has a 3 GB data file and a 1 GB transaction log file. You want to optimize database performance on both databases. You also want to minimize administrative overhead.
What should you do?
选项
A、Shrink the empty data file on drive E.
Place the new data file and the new log file on drive E.
B、Shrink the empty data file on drive E.
Backup and shrink the log file on drive C to 2 GB.
Place the new data file on drive E and the new log file on drive C.
C、Shrink the data file on drive D to 1 GB, and then shrink the data file on drive E to 2 GB.
Place the new data file on drive D and the new log file on drive E.
D、Shrink and delete the data file on drive C, and then shrink the database files on drives D and E so that they are both 2 GB.
Place the new data file and the new log file on drive C.
答案
B
解析
Explanation: We must add a new 3GB database with a 1GB transaction log file. Currently we have database that is using 4GB for data and 3GB for the log file. We should place the log file and the data file on two different physical disks out of performance reasons.
The command DBCC SHRINKFILE with the EMPTYFILE option can be used to shrink a datafile to empty. The data will be migrated to the other files in the filegroup. We use this method to free 4.5 GB on Drive E. Then we backup the log file on C and reduce it to 2GB. Then we put the database data file on drive (3GB) and put the log file of the new database on drive C (1GB).
Incorrect answers:
A: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.
C: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.
D: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.
转载请注明原文地址:https://kaotiyun.com/show/OuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Afterthedotcomboomofthe1990s,theworldisabouttoexperienceaboomindots.Over1,000newgenerictop-leveldomainnam
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Cancerisusedgenericallyformorethan100differentdiseases,includingmalignanttumoursofdifferentsites,suchasbreast,
Youliveinaroomincollegewhichyousharewithanotherstudent.Youfinditverydifficulttoworktherebecauseyourroomma
Afterbeinginvolvedinanaccident,youwerelookedafterbyanotherperson.Writealetterofthanks:1)mentioningwhath
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Intheidealizedversionofhowscienceisdone,factsabouttheworldarewaitingtobeobservedandcollectedbyobjectiveres
BedwettingMillionsofkidsandteenagersfromeverypartoftheworldwetthebedeverysinglenight.It’ssocommonthatt
Itwassupposedtobethenew-mediaelection.E-mail,blogging,socialnetworkingandtweetingwereexpectedtosurgeinimporta
随机试题
求不定积分
药物鉴别反应A、加酸产生白色沉淀B、与硝酸银反应产生黑色沉淀C、麦芽酚反应D、硫色素反应E、三氯化锑反应维生素A
某市政府为鼓励市属酒业公司多创税利,市长与酒业公司董事长签订合同约定:酒业公司如果完成年度税收一百万元的指标,第二年董事长和全公司职工都可以加两级工资。该合同属于()性质的行为。
招标人与中标人不按照招标文件和中标人的投标文件订立合同的,下列说法正确的是( )。
企业产品的竞争力,主要取决于产品自身的性价比,当企业的产品定价不再具有竞争力或质量出现不稳定状况时,可能会产生经营上的问题。()
计算机中访问速度最快的存储器是()。
下列选项中,民居建筑与地域对应不正确的是()。
某商场在促销活动期间贴出醒目告示,“本商场家电一律试用20天,满意者付款”。王某从该商场搬回冰箱一台,试用期满后退回,商场要求其支付使用费100元。下列哪一种说法是正确的?()
印度德里苏丹时期实行国家土地所有制,苏丹以服军役为条件分封给穆斯林战士的土地称为
在“学生”表使用“照片”字段存放照片,在使用向导为该表创建窗体时,“照片”字段使用的默认控件是
最新回复
(
0
)