首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
12
问题
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
微软认证
相关试题推荐
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
在一些农业地区逐步形成的大家一起收获庄稼的合作习惯属于()
在晶闸管换相期间,由于换相造成的电源电压换相“缺口”应不大于该瞬间电源电压的()。
产业发展后期以()产业为重点。
周某出售劣质食品,导致购买其食品的张某食用后中毒住院抢救,周某的这一违法行为尚未构成犯罪,对此,周某应当()。
社会协同治理机制是指政府出于治理需要,通过发挥其主导作用,构建制度化的沟通渠道和参与平台,在始终保护并尊重社会的主体地位以及社会自身的运作机制和规律下,加强对社会的支持培育,并与社会一起,发挥社会在自主治理、参与服务、协同管理等方面的作用。形成政府主导、社
提出胆计质、多血质、黏液质和抑郁质概念的学者是()。
(2011上监理)网络图是由箭线和节点组成,用来表示工作流程的有向网状图形。在单代号图中,箭线表示______。
Windows7中,在控制面板中,通过(32)________________可以查看系统的一些关键信息,如显示当前的硬件参数、调整视觉效果、调整索引选项、调整电源设置及磁盘清理等。
假设在数据库表的表设计器中,字符型字段“性别”已被选中,正确的有效性规则设置是()。
A、Statesmustsetahigherminimumwagethanunderfederallaw.B、Statesmustforbidsmallcompaniestosetalowminimumwage.
最新回复
(
0
)