首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
35
问题
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
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
随机试题
判断营养不良程度的重要指标之一是
铸造金属全冠颈部肩台宽度不小于
A省甲公司拟于2008年向欧盟出口钨粉80吨,2007年8月6日,甲公司向A省商务厅申请办理钨粉出口许可证,被告知钨产品出口配额由A省人民政府行政许可服务中心集中分配,甲公司于2007年8月13日向行政服务中心报送申请钨粉出口许可证材料。行政许可服务中心人
当事人一方依照法定解除的规定主张解除合同的,应通知对方合同自( )时解除。
施工占用慢行道和便道要获得()部门的批准。
一、注意事项1.本题本由给定资料与作答要求两部分构成。考试时限为150分钟。其中。阅读给定资料参考时限为40分钟,作答参考时限为110分钟。2.请在题本、答题卡指定位置上用黑色字迹的钢笔或签字笔填写自己的姓名和准考证号,并用2B铅笔在
在我国,中央国家机关的领导人都是由全国人民代表大会选举产生的。()
下列所列情形中,哪些构成生产、销售伪劣产品罪?()
Whichofthefollowingcountrieshasenjoyedthefastesteconomicgrowthinhistory?Whatisthemostimportantfactorthatlea
Vegetarianswouldprefernottobecompelledtoeatmeat.Yetthereversecompulsion(强迫)ishiddenintheproposalsforanewp
最新回复
(
0
)