首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
39
问题
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
微软认证
相关试题推荐
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
SupposeyouarethedeanofEnglishDepartmentofNanfangUniversity,andoneofyourseniorstudents,ZhangQuan,isentrusted
Youarethepresidentofacompany.WriteamemotoSallyCooper,theHRmanagerontheemployeestrainingoncomputerto,1
Forthefirsttime,GeorgeBushhasacknowledgedtheexistenceofsecretCIAprisonsaroundtheworld,wherekeyterroristsuspe
Themethodsoftestingaperson’sknowledgeandabilityremainasprimitiveasevertheywere.Afteralltheseyears,education
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
YouaretheadministratorofaSQLServer2000computernamedSQL1.Youwanttoperformadhocdistributionqueriesagainstada
随机试题
关于H+对呼吸的调节,错误的是
成釉细胞瘤好发部位是
有机磷农药中毒所出现的症状分为()。
《大气污染防治法》规定,国家建立重点区域大气污染()机制,统筹协调重点区域内大气污染防治工作。
下列关于工程网络计划关键工作的表述中,正确的是( )。
(2007年)甲、乙、丙、丁共同投资设立了A有限合伙企业(以下简称A企业)。合伙协议约定:甲、乙为普通合伙人,分别出资10万元;丙、丁为有限合伙人,分别出资15万元;甲执行合伙企业事务,对外代表A企业。2006年A企业发生下列事实:2月,甲以A企业的名义
某企业2006年末产权比率为80%,流动资产占总资产的40%。有关负债的资料如下:资料一:该企业资产负债表中的负债项目如下所示:负债项目金额流动负债:短期借款2000应付账款3000预收账款2500其他应付款4500一年内到期的长期负债40
秘密等级是指划分公文保密的级别,目前分为()
党的十八届三中全会对全面深化文化体制改革作出了新的重大战略部署,主要有
uniondt{inta;charb;doublec;}data;以下叙述中错误的是
最新回复
(
0
)