首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the datab
You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the datab
admin
2009-05-19
36
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit.
Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement:
UPDATE QuotationSummary
SET CustomerName = ‘Jean-Paul Deloria’
WHERE QuotationID = 12
When the application executes the statement, the developers receive the following error:
Server: Mrh4403, Level 16, Stats 1, Line 1
View or function ‘QuotationSummary’ is not updateable because it contains aggregates:
You want developers to be able to use this UPDATE statement without generating errors. What should you do?
选项
A、Create an INSTEAD OF trigger on the view to update the composite tables.
B、Grant the developers UPDATE permissions on each base table.
C、Add a cascading update trigger on each base table.
D、Create a QuotationSummary table and populate the table with data from the base tables.
答案
A
解析
Explanation: SQL Server 2000 uses INSTEAD OF triggers and partitioned views to enhance the class of updateable views. INSTEAD OF triggers can be created on a view in order to make a view updateable. The INSTEAD OF trigger is executed instead of the data modification statement on which the trigger is defined. This trigger allows the user to specify the set of actions that need to take place in order to process the data modification statement. Thus, if an INSTEAD OF trigger exists for a view on a given data modification statement, the corresponding view is updateable through that statement. If the view is a partitioned view, the view is updateable, subject to certain restrictions.
Incorrect Answers:
B: Before a user can use a database; they must be given certain permissions that are determined by the type of activity they will be permitted on the database. To run UPDATE statements against a database the user must be granted UPDATE permissions. This can be specified at the table or database level. In this scenario, granting the permission at the database level would require less administrative effort. However, the error message is not related to permissions but to the updateability of the table.
C: Cascading referential integrity constraints makes it possible to define the actions SQL Server 2000 takes when a user attempts to delete or update a key to which existing foreign keys point. Cascading referential integrity constraints fire AFTER triggers after all of the cascading referential actions directly caused by the original DELETE or UPDATE are performed.
D: Creating a table that combines the composite tables that the view is based on would deny us the ability to use the view to return aggregated column values.
转载请注明原文地址:https://kaotiyun.com/show/huhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
随机试题
黄芩软化韵最佳方法是
华意公司委托W会计师事务所对其2005年度的会计报表进行审计,王注册会计师作为项目负责人全面关注该公司的内部控制和经营状况,在审计过程中,他需要及时解答助理人员的问题,也要及时复核助理人员的工作底稿,其中发现一些问题,请代为作出专业判断。
适用于中低层管理人员掌握管理的基本原理、知识,提高管理能力的方法是()。
对()的准确统计是国家从宏观上了解员工生活水平的重要依据,也是企业掌握人工成本的主要信息来源。
美术教材里经常会有一些美术作品,尤其是一些外国美术作品中的人物形象很多都是半裸或者是全裸的。每当看到这些,学生们的反应都很怪异,有些胆子大的男同学就发出怪声,女同学就赶紧低头或保持沉默。在一次美术课上,王老师提问,要求学生对雕塑作品分类,一位男同学说:“雕
利克特(R.A.Likert)提出的态度测量方法是
(2013下集管)项目章程是正式批准一个项目的文档,项目章程的内容不包括______。
下面描述中错误的是( )。
A、Helosteverythingincludinghiscomputer.B、Hesufferedfromaseriouscaraccident.C、Hewentabroadtojoinhisfamily.D、H
A、Avacationandartcollection.B、Atripandanewcar.C、Cashandacar.D、Moneyandatrip.D四个选项都是名词词组,初步猜测题目与物件有关。对话说,大奖是3万
最新回复
(
0
)