首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
36
问题
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
微软认证
相关试题推荐
Whenpeopletalkabouta"north-southdivide"inBritain,theyusuallyrefertohouseprices,employmentandtheratioofprivat
"3M"comesfrom"MinnesotaMining&Manufacturing,"butthosethreeMsmightbetterstandforMistake=Magic=Money.Throughoutit
Writealettertooneofyourfriends,apologizingtohim/herforyourmakinghis/hercomputerstopworking.Youshouldwrite
Inthefollowingtext,somesentenceshavebeenremoved.ForQuestions41-45,choosethemostsuitableonefromthelistA-Gto
Ifsoldieringwasforthemoney,theSpecialAirService(SAS)andtheSpecialBoatService(SBS)wouldhavedisintegratedinre
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
在用户管理组administrators中删除lusi用户。
随机试题
慢性生物性假阳性反应的梅毒血清试验,发生最高的是下列哪一种疾病
下列哪一项不是氯丙嗪的不良反应
据临床统计,约有多少患者需要心理诊断和治疗
下列独立经济核算的企业或单位不能成为企业所得税的纳税人的有( )。
某会计师事务所拥有170万元的流动资产及90万元的流动负债,下列交易可以使该事务所流动比率下降的有()。
国际信用的主要形式有()。
某高档居民小区位于城市繁华地段,入住人口约2万人,小区内有餐饮、超市及茶楼数十家,考虑到部分业主经营生意及便于顾客出入,小区基本没有实施封闭管理。根据上述情况,你认为该小区存在的最大治安风险是()。
论述我国社会主义法律体系的主要特色与内容。(2012论70)
下列各序列中不是堆的是
Whatdoesthemanwanttoknow?
最新回复
(
0
)