首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database is configu
You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database is configu
admin
2009-05-19
19
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database is configured as shown in the exhibit.
Users frequently need details about parts. Users search for data by using the following query.
SELECT Parts.SKU, Locations.Description, Manufacturer.Name,
PartsLocations.Qty, PartsLocations.LastInventoried
FROM Parts
INNER JOIN Manufacturer ON Parts.ManufacturerID=
Manufacturer.ManufacturerID
INNER JOIN PartsLocation ON Parts.PartID = Parts.Location.PartsID
INNER JOIN Locations ON Parts.LocationID= Locations.LocationID
WHERE SKU?
You need to accelerate query response time. What should you do?
选项
A、Create a parameterised stored procedure to retrieve the data.
B、Create a denormalized table that is maintained by triggers.
C、Use ad hoc queries to retrieve the data.
D、Create a nonclustered index on the primary key of each table.
答案
D
解析
Explanation: A nonclustered index is similar to an index in a textbook. The data is stored in one place, the index in another, with pointers to the storage location of the data. The index contains entries describing the exact location in the table of the data values being searched for in the queries and should be used for columns that contain a large number of distinct values; queries that do not return large result sets; columns frequently involved in search conditions of a query that return exact matches; and decision-support-system applications for which joins and grouping are frequently required. Create multiple nonclustered indexes on columns involved in join and grouping operations, and a clustered index on any foreign key columns.
Note: A better solution, not listed here, would to create clustered indexes on the primary keys and nonclustered indexes on the foreign keys.
Incorrect Answers:
A: A parameterized query would not improve performance.
Parameterized queries are SQL queries written for reusability. They contain parameter markers as placeholders for data that will change from execution to execution. In the Data Transformation Services (DTS) tasks that use parameterized queries.
B: Reasonable normalization often includes few regularly executed queries that use joins involving more than four tables. In this scenario four tables are being joined in the query. The normalization here is thus permissible.
Note: Database normalization often improves query performance. When useful indexes are available, the SQL Server 2000 query optimizer can select rapid, efficient joins between tables.
Normalization is advantageous as it aids faster sorting and index creation; enables a larger number of clustered indexes; allows for narrower and more compact indexes; reduces the number of indexes per table, which improves the performance of INSERT, UPDATE, and DELETE statements; and reduces null values and the opportunity for inconsistency, which increase database compactness.
However, as normalization increases, so do the number and complexity of joins required to retrieve data. Too many complex relational joins between too many tables can hinder performance.
C: An ad hoc query is a query that is composed for a particular task. The code in this scenario is an example of an ad hoc query.
转载请注明原文地址:https://kaotiyun.com/show/GuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Writeanessayof160~200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
Afterbeinginvolvedinanaccident,youwerelookedafterbyanotherperson.Writealetterofthanks:1)mentioningwhath
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Emilyislisteningtonetworktrafficandcapturingpasswordsastheyaresenttotheauthenticationserver.Sheplanstouseth
随机试题
下列属于《公民道德建设实施纲要》所提出的职业道德规范的是()。
A.肛门周围脓肿B.直肠息肉C.肛裂D.血栓性外痔E.肛管癌便后滴血、剧痛()
侵蚀性葡萄胎多发生在葡萄胎排空后
一般来讲,我国的商业银行实行的是()。
按燃气管道的( )来划分,燃气管道可以被分为长距离输送管道、城市燃气管道和工业企业燃气管道。
登记结算公司按照银货对付原则全面调整结算制度时,融资融券交易交收违约的处理措施和程序相应调整。()
假设W公司2003年12月31日应收账款有2000,户顾客,注册会计师确定的抽样误差为±6万元,考虑到内部控制及抽样风险的可接受水平,注册会计师确定可信赖程度为95%(查表可得可信赖程度系数为1.96),同时注册会计师估计总体的标准离差为150元。
关于“地球日”的表述,错误的是()。
∫0+∞=___________。
一般情况下,当对关系R和S进行自然连接时,要求R和S含有一个或者多个共有的
最新回复
(
0
)