首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
70
问题
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
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Youareanactivememberofthestudentnewspaper.Thenewspaperiscurrentlylookingforajournalistforthesummersemester.
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
随机试题
机体组织液和血浆相同的是
脾的阳气失调病机,下列哪项是不确切的
A.四逆加人参汤B.人参养荣汤C.阳和汤D.八珍汤合桂枝汤E.四妙勇安汤冷伤阴盛阳衰证型的治疗选用
A.胶原纤维互相融合B.血浆蛋白渗入血管内C.肾小管上皮吞饮吸收大量血浆蛋白D.前角蛋白成分在肝细胞内聚集E.免疫球蛋白在浆细胞内堆集马洛里(Mallory)小体
甲有三个子女,儿子潘一、潘二和女儿潘三。潘三有四个子女张一、张二、张三和张四。潘三于1996年5月死亡,甲于2003年8月死亡,生前没有遗嘱,留有存款2万元。张一、张二、张三和张四作为代位继承人,应继承的份额是:()
某次数学考试结束后,甲班班长和学习委员一起对考试成绩进行了预测,具体如下: 1.有人考试没及格。 2.有人考试及格了。 3.班长考试没及格。 成绩公布后,发现三句预测中只有一句话正确。可推知:
关于浏览器安全性的描述中,正确的是()。
WhatisMs.Bush’smainpurposeforthetrip?
•Lookatthenotesaboutthekeytrendsinthemilkdrinksmarket.•Someinformationismissing.•Youwillhearpartofapre
InBritainthereisaNationalHealthService(NHS)whichispaidforbytaxesandNationalInsurance,andingeneralpeopledo
最新回复
(
0
)