首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently
You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently
admin
2009-05-19
42
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently added a hard disk to the server and configured the database.
The data files are configured as shown in the Database Properties exhibit.
The database is configured as shown in the Database Schema exhibit.
Each primary key is clustered. All foreign keys contain nonclustered indexes. You want to use the space on the new hard disk to make the database respond more quickly to queries.
What should you do?
选项
A、Re-create the Notes table on the SECONDARY filegroup.
B、Re-create the nonclustered indexes on the SECONDARY filegroup.
C、Re-create the Patients and Doctors tables and their indexes on the SECONDARY filegroup.
D、Re-create the Cases and Notes tables and their indexes on the SECONDARY filegroup.
答案
B
解析
Explanation: With SQL Server 2000 it is possible to create tables or indexes on specific filegroups. This allows us to control where the database’s tables and indexes are physically located as filegroups can be placed on different hard drives.
Placing heavily accessed tables in one filegroup and the table’s nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes. However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table.
Incorrect Answers:
A, C, D: With SQL Server 2000, placing the tables and their nonclustered indexes in different filegroups that are located on different physical drives provides better performance than placing tables in different filegroups and on different physical drives.
转载请注明原文地址:https://kaotiyun.com/show/AuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
Austerityisawordoftenfoundonthelipsofpoliticiansandeconomistsatthemoment,butitisseldomheardfromtechnologis
新载树木根系与土地新的平衡的建立与________有关。
[背景资料]某建筑集团公司三公司通过公开投标中标南方某省会城市一五星级宾馆工程。为了抢进度,外装修阶段,施工单位未经批准擅自决定改变原施工组织设计中外装饰用吊篮的方案,改为搭设钢管扣件式双排脚手架。但未经认真设计,只拟出一份简单的搭设方案,要求立
中国公民王某就职于国内A上市公司,2013年收入情况如下:(1)1~8月份,王某每月获得工资8500元。(2)1月1日起将其位于市区的一套公寓住房按市价出租,每月收取租金6800元。1月因卫生间漏水发生修缮费用1200元,已取得合法有效
商业银行的经营原则有()。
玄奘,通称三藏法师,俗称唐僧,洛阳偃师缑氏人,佛教经典的著名翻译家,中国佛教唯识宗的创始人,撰有()。
三个或三个以上的音按一定的音程关系结合起来,形成了_________。
关于冷血动物,下列说法错误的是()。
Thefirstpersonwhousedtheword"boldfaced"isToday,"thebold-facednames"isusedtoreferto
题目2:口试教师;两位考生时:SaytoCandidateB:(handingacardtoB)B,hereisacartforyou.Now,askAfivequestionsabouthis/hers
最新回复
(
0
)