首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
37
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
在用户管理组administrators中添加本地用户“sy”。
随机试题
_______是宋代影响最大的诗歌流派。
邓小平理论成熟并形成理论体系的标志是1992年邓小平南巡和党的十四大召开。()
用橡皮圈直接套在牙上,以关闭替牙期上中切牙之间的间隙,会形成
A.举元煎B.大补元煎C.保阴煎D.固阴煎E.失笑散治疗月经过多气虚证,应首选
女,35岁。发现左颈部前一无痛性肿块1年,约1cm大小。近1个月来出现声音嘶哑。查体:甲状腺左下极质硬结节,直径1.5cm,随吞咽活动。颈部未触及肿大淋巴结。最可能的诊断是
宏观经济政策对投资理财具有实质性的影响,下列说法正确的是()。
2008年端午节放假期间,小李准备去马来西亚旅游,当他到银行兑换美元的时候.银行工作人员告诉他,1美元兑换6.95元人民币,工作人员的这种说法用的有()。
出于安全考虑,使用年限超过10年的电梯必须更换钢索。在必须更换钢索的电梯中有一些是S品牌的。所有S品牌电梯都不存在安全隐患。由此可以推出()。
学生已经有了“鸟”的观念,再学习“百灵鸟”这种动物。这种学习是()。
与矩阵A=相似的矩阵为().
最新回复
(
0
)