首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
7
问题
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
微软认证
相关试题推荐
About3billionpeoplelivewithin100milesofthesea,anumberthatcoulddoubleinthenextdecadeashumansflocktocoasta
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Afterthedotcomboomofthe1990s,theworldisabouttoexperienceaboomindots.Over1,000newgenerictop-leveldomainnam
MusicalTrainingCanImproveCommunicationSkillsAmericanscientistssaymusicaltrainingseemstoimprovecommunicationsk
Writeanessaybasedonthechart.Inyourwriting,youshould1)describethediagram,and2)giveyourcomments.Y
Forthefirsttime,GeorgeBushhasacknowledgedtheexistenceofsecretCIAprisonsaroundtheworld,wherekeyterroristsuspe
UsingFacebookmakespeoplesadder,atleastaccordingtosomeresearch.Burjustwhatisitaboutthesocialnetworkthattakes
UsingFacebookmakespeoplesadder,atleastaccordingtosomeresearch.Burjustwhatisitaboutthesocialnetworkthattakes
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
下列哪种状况不属于70年代以来证券市场出现的新特征()
在许多情况下,国际部结构最主要的缺点是国际部往往过分地依赖国内的研发部门。()
应考虑为对于出现呼吸肌麻痹的重症患者的治疗应该
物体在受到两个力的作用时,如果能保持静止状态或匀速直线运动状态称二力平衡。二力平衡的条件不包括()。
在健康保险合同中通常都有规定:“不承保合同生效前的任何疾病或症状。”这是为了避免客户“带病投保”的道德风险。对于投保人来说,购买医疗保险产品,向保险公司如实告知健康状况和既往病史等信息非常重要。因为这些信息会影响到保险公司的承保决定以及保费水平。而医疗保险
甲、乙两人各自阅读同一本书,从同一天开始阅读,3天后,甲已经读完,乙还差一天的阅读量才能读完,如果此时甲、乙两人共阅读的页数为350,则这本书有()页。
[*]
将Cisco路由器的配置保存在NVRAM中,正确的命令是()。
在提示符下,要修改数据库TEST.DBF的结构,应用命令()。
A、Inthefactory.B、Inthearmy.C、Inthepoliceforce.D、Insports.D
最新回复
(
0
)