首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
65
问题
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
Evenbeforetheopeningceremony,arecordhadbeenbrokenatSochi:12newevents,themostforanyOlympics,werescheduledto
Evenbeforetheopeningceremony,arecordhadbeenbrokenatSochi:12newevents,themostforanyOlympics,werescheduledto
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
随机试题
腹部闭合性损伤手术治疗的目的是
犬,3月龄,购回1月余,对主人的呼唤无反应,饮、食欲正常。该犬首先需要检查的脑神经是()。[2010年真题]
警察甲与乙开玩笑,随手拿起执勤时放在桌上的手枪向乙瞄准、开枪,并同时戏称“我一枪打死你”,不料枪中有子弹,乙被当场打死,甲的行为是?
在现有工程价格资料的基础上,经过分析整理用于编制项目建议书、可行性研究报告投资估算的依据的是()。
下列不属于注册消防工程师职业道德原则特点的是()。
申请电子报检的报检企业应具备的条件有( )。
一个国家实行什么样的政治制度,走什么样的政治发展道路,必须与这个国家的国情和性质相适应。走中国特色社会主义政治发展道路的关键是()。
窗体上有Text1、Text2两个文本框及一个命令按钮Commandl,编写下列程序:DimyAsIntegerPrivateSubCommand1_Click()DimxAsIntegerx=2
下面程序的运行结果为()。#include<iostream>usingnamespacestd;voidmain(){for(inta=0,x=0;!x&&a<=10;a++);cout
A、Theyrealizedsomecompaniesexploitedthemovement.B、Theydidn’tknowwhattodo.C、Theydidn’trealizesomecompaniesmade
最新回复
(
0
)