首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named Customers, which is used by a cust
You are the administrator of a SQL Server 2000 computer. The server contains a database named Customers, which is used by a cust
admin
2009-05-19
42
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named Customers, which is used by a custom client/server application.
The database contains more than 1 million rows. Users report that the database responds slowly when they search for customers by using the application. Users search for customers by scrolling through an alphabetical list of customer names.
You use SQL profiles to capture information about how the application uses the database.
You receive results as shown in the following screen shot.
You need to improve the application’s performance. What should you do?
选项
A、Create additional nonclustered indexes on the CustomerInformation table.
B、Rewrite the application so that it uses a user-defined function to return the customer list.
C、Rewrite the application so that it uses a query with a WHERE clause to search for customer names.
D、Rewrite the application so that is uses a stored procedure to return the customer list.
答案
C
解析
Explanation: The WHERE clause of the SELECT statement causes the queries to be selective. Without the WHERE clause all records in the selected table is included in the result set. The WHERE clause tells SQL Server 2000 which data should be returned and thus limits the returned data to only that data that meets the condition set in the WHERE clause. This would improve the efficiency of the application.
Incorrect Answers:
A: Nonclustered indexes are useful for exact match queries because these indexes contain entries describing the exact location in the table of the data values being searched for. However, the application in this scenario does not make use of exact match queries.
B: Since functions only return a single value, not a recordset, they cannot be used in this scenario.
Note: In programming languages, functions are subroutines that are used to encapsulate frequently performed logic. Any code that must perform the logic incorporated in a function can call the function rather than having to repeat all of the function logic. In addition to built-in functions, SQL Server 2000 also allows us to define our own Transact-SQL functions using the CREATE FUNCTION statement. These user-defined functions can take zero or more input parameters, and can return a single value. Some user-defined functions can return a single, scalar data value or decimal value.
D: A stored procedure could be used but would not, by itself, improve any performance gain except that small gain of caching the execution plan.
Note: A stored procedure is a group of Transact-SQL statements tat are compiled into a single execution plan. SQL Server 2000 stored procedures return data as output parameters, which can return either data or a cursor variable; return codes, which are always an integer value; a result set for each SELECT statement contained in the stored procedure or any other stored procedures called by the stored procedure; or as a global cursor that can be referenced outside the stored procedure. They assist in achieving a consistent implementation of logic across applications.
The SQL statements and logic needed to perform a commonly performed task can be designed, coded, and tested once in a stored procedure. Each application needing to perform that task can then simply execute the stored procedure. Stored procedures can also improve performance.
转载请注明原文地址:https://kaotiyun.com/show/SuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
宽度小于1m的窗间墙,应选用整砖砌筑,半砖和破损的砖,应分散使用于()。
第二审人民法院对上诉案件,需要开庭审理的,应当()。
关于证券市场线与资本市场线,下列说法正确的是()。
()对学生提交的国家助学贷款申请材料进行资格审查,对其完整性、真实性和合法性负责。
根据《中华人民共和国合伙企业法》的规定,合伙人对合伙企业有关事项作出决议,按照合伙协议约定的表决办法办理。合伙协议未约定或者约定不明确的,实行()的表决办法。
“消费者获得赔偿权”中所指的享有求偿权的主体,具体包括()。
在弹簧弹力的作用下,一质量为m(m未知)的小球开始振动,弹力与位移的关系为F=-kx,而位移x=Acosωt。其中,k、A和ω都是常数,求:小球的质量m。
根据下列资料,回答下列问题。从材料中我们可以得出:
《中华人民共和国合同法》第99条规定:“当事人互负到期债务,该债务的标的物种类、品质相同的,任何一方可以将自己的债务与对方的债务抵销,但依照法律规定或者按照合同性质不得抵销的除外。当事人主张抵销的,应当通知对方。通知自到达对方时生效。抵销不得附条
Computersmayonedayturnnightintoday-withgoodold,naturalsunlight.Giantcomputer-controlledmirrors,thousandsoff
最新回复
(
0
)