首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
54
问题
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
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
TheUniversityNewspaperisrecruitingsomejournalists.WriteamemoonJune1,2009toallstudents,explaining1)therequirem
SupposeyouphonedyourfriendMaryseveraltimesyesterdaybutshedidn’tansweryourcallatall.Writeheranemailto1
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
可引起嗜睡,对驾车、高空作业或操作机器者宜谨慎,对妊娠期妇女、严重高血压者、有精神病史者禁用的是
不宜与生物碱类药物配伍的是抑制肠粘膜中的各种酶活性的是
(2015年真题)下列思想家中,将法的本质归结为人的理性的有()。
背景资料:A公司企业法人为张三,A公司成立B项目部负责承建某码头工程,任命李四为项目经理。在2013年4月5日施工过程中,B项目部发生一起重大安全生产责任事故。2013年5月20日按照《生产经营单位安全生产不良记录“黑名单”管理暂行规定》,国家安监总局将A
按照网络覆盖的地理范围的大小,可将计算机网络分为()。
我国某公司出口一批服装到美国,打算以CFR条件对外报价,下列属于该公司在考虑运费时应考虑到的因素的是()。
公司型基金委托()作为专业的投资顾问来经营与管理基金资产。
对于单项金额重大的应收款项,应当单独进行减值测试。有客观证据表明其发生了减值的,应当根据其未来现金流量现值低于其账面价值的差额,确认减值损失,计提坏账准备。()
“_________”是周代开始的乐器的分类法。
在结构化方法中,软件功能分解属于下列软件开发中的阶段是
最新回复
(
0
)