首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot
admin
2009-05-19
34
问题
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.
You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.
You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?
选项
A、Increase the maximum file size of Sales_Data to 1,500MB.
B、Use the DBCC SHRINKDATABASE statement.
C、Set automatic file growth to 10 percent.
D、Create another data file named Sales_Data2 in a new SECONDARY filegroup.
答案
A
解析
Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.
Incorrect Answers:
B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.
C: The database is already set to automatic file growth, but it has reached the maximum size.
D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.
转载请注明原文地址:https://kaotiyun.com/show/7uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Forthefirsttime,GeorgeBushhasacknowledgedtheexistenceofsecretCIAprisonsaroundtheworld,wherekeyterroristsuspe
Restrictionsonthesmokinginpublicplaceshavenotbeensosuccessfulinsomeregions."Second-handsmoking"isgettingserio
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
Insectsaredisappearing.Theworldhas25percentfewerterrestrialinsectsnowthanin1990.Thisincludesthosewerelyon
在用户管理组administrators中删除lusi用户。
Guest账户和Administrator账户一样是由系统建立的,不能被禁用。
YouaretheadministratorofSQLserver2000computer.TheservercontainsadatabasenamedMedicalRecords.Usersaccessmedical
随机试题
Wordslike"bear,nut,knockout"canbecategorizedas_____.()
Whenwetalkaboutintelligence,wedonotmeantheabilitytogetagoodscoreonacertaintest,oreventheabilitytodogen
患右心功能不全的患者,出现比较早的症状是
预防风湿热复发的首选药物为()
1周岁小儿的体重约为出生体重的
动物是否有权利不在于它们能否推理,也不是它们能否说话,而是它们能否感到受苦。我们踢了一下石头,说这样做不符合石头的利益,这样说没有意义,因为石头没有受苦的能力。但动物不一样。你踢一下猫,它叫一声跑开了,我们知道它受苦了。大家可以看到一些现象,就是猫、狗等动
《中共中央、国务院关于加快水利改革发展的决定》提出,提高防汛抗旱应急能力,应建立专业化与()相结合的应急抢险救援队伍。
H公司是东北一家民营企业,1996年创建时仅有50万元资金和5个员工。近年来市场对其产品需求不断升温,吸引了数十家企业进入该地区。该企业产品在市场有一定的竞争能力,企业经济效益也不错。公司规模不断扩大,部门增加到十个,人员发展到150多。创办人自任总经理,
材料:天坛之美始建于明永乐十八年的天坛,是世界建筑艺术的珍品。它具有一种独特的意境,它以凝练的艺术形式表现了博大深邃的精神内涵,体现了中国古人对宇宙的思考和想
在教师职业道德上,我们应该大力肯定和倡导的是()。
最新回复
(
0
)