首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. T
You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. T
admin
2009-05-19
20
问题
You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.
The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
What should you do?
选项
A、Create an UPDATE trigger that sends an e-mail message.
B、Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
C、Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
D、Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
答案
A
解析
Explanation: Adding an appropriate UPDATE trigger that notifies the service manager whenever a complaint is marked is closed would accomplish the requirements. The client applications application would not have to be changed.
Note: In SQL Server 2000, triggers are a special type of stored procedure that fire automatically when an UPDATE, INSERT, or DELETE statement is issued against a table or view. Triggers are powerful tools that can be used to enforce business rules automatically when data is modified and can automate the processing for a company. Like stored procedures, triggers contain Transact-SQL statements which can include instructions to send an e-mail message when a particular column is updated
Incorrect Answers:
B: If a stored procedure is created and used the client application would have to be adjusted
accordingly. But we don’t want to make any changes in the client application.
Note: A stored procedure is a set of Transact-SQL statements compiled into a single execution plan and can 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.
Stored procedures assist in achieving a consistent implementation of logic across applications as the SQL statements and logic needed to perform a task can be coded and tested once in a stored procedure. Thereafter each application or user that needs to perform that task can execute the stored procedure.
Coding business logic into a single stored procedure also offers a single point of control for ensuring that business rules are correctly enforced. Stored procedures can also be used to customize security permissions in much the same way as views. Stored procedure permissions can be used to prevent users from modifying data in certain columns and then grant users permissions to execute the procedure.
C: If a user defined function is created and used the client application would have to be adjusted accordingly. But we don’t want to make any changes in the client application.
Note: In programming languages, functions are subroutines 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. SQL Server 2000 supports built-in functions and user-defined functions.
Built-in functions operate as defined in the Transact-SQL Reference and cannot be modified while user-defined functions allow the user to define their own Transact-SQL functions using the CREATE FUNCTION statement. User-defined functions take zero or more input parameters, and return a single value. Some user-defined functions return a single, scalar data value, such as an int, char, or decimal value.
D: Just creating a rule would only check the input, it would not notify the service manager as required.
Note: Rules are a backward-compatibility feature of SQL Server 2000 and performs the same functions as CHECK constraints. CHECK constraints are the preferred, standard way to restrict the values in a column as they are more concise than rules.
转载请注明原文地址:https://kaotiyun.com/show/zrhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Rao’s,thelegendaryeastHarlemItalianeatery,ismorethanahundredblocksaboveWallStreet.Butwithaclientelethatincl
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
TheChineseScienceandTechnologyPapersBeingIncludedinSCI收录的中国科技论文A.Studythechartscarefullyandwriteanessayof160
Youareanactivememberofthestudentnewspaper.Thenewspaperiscurrentlylookingforajournalistforthesummersemester.
[A]Shopkeepersareyourfriends[B]Remembertotreatyourself[C]Sticktowhatyouneed[D]Livelikeapeasant[E]Balanceyourd
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Insectsaredisappearing.Theworldhas25percentfewerterrestrialinsectsnowthanin1990.Thisincludesthosewerelyon
Itwassupposedtobethenew-mediaelection.E-mail,blogging,socialnetworkingandtweetingwereexpectedtosurgeinimporta
随机试题
搬运昏迷失去知觉的伤员要采取仰卧位。
A.“竹节样”脊椎B.关节肿痛伴高热,白细胞增高C.两者均是D.两者均不是化脓性关节炎
病原携带者作为传染源意义的大小,主要取决于
肝郁不孕首选方是肾阳虚不孕首选方是
国家间贸易壁垒可分为关税壁垒和非关税壁垒两大类,关税壁垒主要包括()等。
泡沫产生装置进场检验时,下列检查项目中,不属于外观检查项目的是()。
对公司银行贷款逾期的罚息,正确的财务或税务处理是()。
2020年7月1日,甲公司开始动工建造一栋自用办公楼,预计工期为1.5年。为建造该办公楼,该公司已于2020年3月31日借入一笔款项,金额为6000万元,期限为3年,年利率为5%。另外,本工程还占用了于2019年1月1日借人的一笔一般借款,金额为500
设二维随机变量(X,Y)的概率密度为f(x,y)=。求条件概率P{Y≤1|X≤1}。
Foreachblank,choosethebestanswerfromthefourchoicesandwritedownontheanswersheet.(66)isasixbytesOSIlayer2
最新回复
(
0
)