首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
Exhibit: UPDATE EzonexamConsolidated SET District = ‘Mexico’ WHERE RtvID = 45 You work as database administrator at Ezonexam.co
Exhibit: UPDATE EzonexamConsolidated SET District = ‘Mexico’ WHERE RtvID = 45 You work as database administrator at Ezonexam.co
admin
2009-05-19
18
问题
Exhibit:
UPDATE EzonexamConsolidated
SET District = ‘Mexico’
WHERE RtvID = 45
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.
When users run the query in the exhibit above the receive the following error message:
Server: Mrh3612, Level 16, Stats 1, Line 1
View or function ‘EzonexamConsolidated’ is not updateable because it
contains aggregates:
How should you enable the query to run?
选项
A、Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.
B、The appropriate users should be granted UPDATE permissions on each base table.
C、To enable updates on the composite tables create an INSTEAD OF trigger on the view.
D、On each base table add a cascading update trigger.
答案
C
解析
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:
A: 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.
B: The error message is not related to permissions but to the updateable of the table.
D: 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.
转载请注明原文地址:https://kaotiyun.com/show/DuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
抽样调查的方式主要包括
A.怒则气上B.喜则气缓C.悲则气消D.恐则气下E.思则气结可使心气涣散,神不内守的是()。
下列案件事实中,并非由被告承担举证责任的是?
在中国,劳教属于行政处罚,针对的只是尚不构成刑事处罚的、轻微的违法行为。但在实践中,劳教有时比刑事处罚还要严厉。同时,劳教制度的一些规定模糊不清,也给公安机关在执行中滥用权力;侵犯人权留下了空间。把劳教制度放在“依法治国,依法执政”这样一个大的社会背景下思
资料处理方法的检验应满足有同样使用价值的土地,在相同的市场条件下,应该有不同的价格。()
金融的基本职能是为经济运行()。
Ifsomeonesays"Iknowtheword",heshouldnotonlyunderstanditsmeaningbutalsobeabletopronounce,spell,and______it.
考生文件夹下存在一个数据库文件“samp2.accdb”,里面已经设计好表对象“tStud”和“tTemp”。tStud表是学校历年来招收的学生名单,每名学生均有身份证号。对于现在正在读书的“在校学生”,均有家长身份证号,对于已经毕业的学生,家长身份证号为
WheneverIspeaktoeducatorsandinterestedlaypeopleaboutneuroplasticity—theabilityoftheadultbraintochangeinfunctio
Whatdidthemanalmostforgettodo?
最新回复
(
0
)