A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?()A.REFERENCESB.SELECTC.UPDATED.ALTER
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?()
A.REFERENCES
B.SELECT
C.UPDATE
D.ALTER
相关考题:
在SQL Server 2000中,某数据库中有角色Role和用户User,User是Role角色的成员,且只属于该角色。先对Table表给Role只授予SELECT和DELETE权限,并授予User对T表具有SELECT、UPDATE和DENY DELETE权限,则用户User对Table表可以执行的操作是______。
SQL Server2005触发器主要针对下列语句创建()。A.SELECT、INSERT、DELETEB.INSERT、UPDATE、DELETEC.SELECT、UPDATE、INSERTD.INSERT、UPDATE、CREATE
在HBase中,创建一张名为“user_c”的表,该表有一个名为“User”的列族,其相应Shell命令应该是()。A.create ‘user_c’, {name => ‘User’};B.create {‘user_c’ => ‘User’};C.create ‘user_c’, {NAME = ‘User’};D.create ‘user_c’, {NAME => ‘User’};
下列哪组SQL命令全部属于数据定义语句的命令?()A.CREATE,DROP,ALTERB.CREATE,DROP,SELECTC.CREATE,DROP,GRANTD.CREATE,DROP,UPDATE
【单选题】对于建立在数据库上的DDL触发器,常用的激活DDL触发器的事件不包括()A.Create_Table,Alter_Table,Drop_TableB.Create_View,Alter_View,Drop_ViewC.Create_Procedure,Alter_Procedure,Drop_ProcedureD.Rollback
数据库对象是数据库的组成部分,常用的数据库对象有表(Table)、索引(Index)、视图(View)、图表(Diagram)、用户(User)、()等。A.默认值(Default)B.规则(Rule)C.触发器(Trigger)D.存储过程(Stored Procedure)
2、在HBase中,创建一张名为“user_c”的表,该表有一个名为“User”的列族,其相应Shell命令应该是()。A.create ‘user_c’, {name => ‘User’};B.create {‘user_c’ => ‘User’};C.create ‘user_c’, {NAME = ‘User’};D.create ‘user_c’, {NAME => ‘User’};