首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
46
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
重新点燃启蒙的火炬在告别20世纪而进入21世纪之际,中国思想界对启蒙有截然相反的看法。有人历数启蒙的罪状,劝告知识分子放弃启蒙立场;有人则回顾启蒙被压倒的悲剧,希望在中国“重新点燃启蒙的火炬”。面对思想界的矛盾和种种困惑,有一个问题必须回答:今日
静脉肾盂造影对以下哪种疾病最有诊断价值
前置胎盘的处理,以下哪项错误
根据供求总量和结构的关系以及总需求和总供给在国民经济运行中的不同特点,短期应以需求调节为主,中长期应以供给调节为主。其原因正确的有()。
对列入“实施检验检疫的进出境商品目录”和其他法律、法规规定必须经检验检疫机构检验的出口商品的运输包装,进行性能检验,未经检验或检验不合格的,不准用于盛装出口商品。()
在计算披露的经济增加值时,涉及的会计调整很多,其中经济增加值要求对某些大量使用长期机器设备的公司,处理方法是按照更接近经济现实的()。
甲:“你认为电视剧《心术》演得好吗?”乙:“我认为不算好。”甲:“那就是说,你认为坏了?”乙:“不,我并没有说坏。”甲:“说不好就是坏!”以下哪个选项不可能是对甲、乙对话的正确评价?
民革上海市委长期关注公共财政问题,曾以此为题连续两年在市政协全会上作大会发言。“财政预算科目分‘类、款、项、目、节’五个层次,但目前政府向人大代表提交的财政信息大多是到‘款’,有的仅仅为‘类’,人大代表要在全会会期内,全面厘清这些款项并不容易。”
MBA
Researcherswhorefusetosharedatawithothersmay【51】otherstowithholdresultsfromthem,【52】astudybyhealth-policyanalys
最新回复
(
0
)