首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
67
问题
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
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
TheBestMediatoUseThereareplentyofoptionsavailableforspreadingnews,suchasnewspapers,radio,TV,theInternet
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
随机试题
中国共产党的最高理想是()
最早将咳嗽分为外感、内伤两大类的是:
现在急诊室内一位75岁男性,头晕,无规律心悸,轻微活动受限1周,12导联心电图显示房颤,监护器上心率100~120bpm,下列治疗最恰当的是
下列现象属于物理配伍变化的是()。
患儿,8岁,患上呼吸道感染2周后,出现食欲减退、乏力、尿少、水肿。T37.5℃,BP增高。尿蛋白、红细胞各(+),补体c3降低。诊断为急性肾小球肾炎。其首选的护理诊断/问题是
下列交易或事项中,会引起当期现金流量表中投资活动产生的现金流量发生增减变动的是()。
设当x→0时,f(x)=∫0x2ln(1+t)df~g(x)=xa(ebx一1),求a,b的值.
若有定义语句:intk[2][3],*pk[3];,则以下语句中正确的是()。
TheMinistryofEducationhasurgedteachersacrossthecountrytoavoidacceptinggiftsfromstudentsortheirparentsontheo
Forthispart,youareallowed30minutestowriteashortessayentitledShouldWeAbandonNuclearPower?Youshouldwriteatl
最新回复
(
0
)