首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
32
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Writeanessayof160~200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
“关爱学生”是教师职业道德的灵魂,教师对待学生成长中出现的“冒犯和过错”,正确的做法是()
关于反射弧的叙述,错误的是
男,30岁。右下6金属全冠黏固一周后脱落,咬合时常有瞬间性疼痛。口腔检查见患者咬合紧,牙冠短,对牙面有银汞合金充填物,脱落的全冠完整。出现咬合时瞬间疼痛最可能的原因是
工器具及生产家具购置费的计算公式为( )。
根据是否诉诸法律,可以将资产清收划分为()
人们常说“教育有法而教无定法”,这反映教师劳动具有_______________。
人生不仅仅是果腹求饱,也不仅仅是对于宏大的目标的追求,还需要一点点奢侈品作为日常生活的点缀。看起来无用之物,其实自有其“无用之用”。奢侈品的意义就在于从一般的日用品中间超拔出来.它交换的价值远远高于使用的价值,象征的意味远远高于实用的意义。它展开的是物体迷
种地:农民
牙周病治疗常用的局部冲洗药物有()。
[2010年1月]某公司的员工中,拥有本科毕业证、计算机登记证、汽车驾驶证的人数分别为130,110,90。又知只有一种证的人数为140,三证齐全的人数为30,则恰有双证的人数为()。
最新回复
(
0
)