为 js 表设置删除触发器,均不允许删除,可以使用命令: Create Trigger on js as .F.

如果要从数据库中删除触发器,应该使用SQL语言的命令()。

A、CREATE TRIGGER

B、DROP TRIGGER

C、REMOKE FOR TRIGGER

D、DISABLE ON TRIGGER

A、CREATE TRIGGER；ALTER TRIGGER；DROP TRIGGER

B、CREATE TRIGGER；UPDATE TRIGGER；DROP TRIGGER

C、CREATE TRIGGER；ALTER TRIGGER；DELETE TRIGGER

D、CREATE TRIGGER；UPDATE TRIGGER；DELETE TRIGGER

以下触发器是当对表11进行()操作时触发。Create Trigger abc on 表11 For insert As ……。

A、只是创建表

B、只是插入

C、只是删除

D、修改、插入、删除

以下触发器是当对[表1]进行()操作时触发。

Create Trigger abc on 表1

For insert , update , delete

As ……

A.只是修改

B.只是插入

C.只是删除

D.修改、插入、删除

删除触发器tri_Sno的正确命令是：()。

A.DELETE TRIGGER tri_Sno

B.TRUNCATE TRIGGER tri_Sno

C.DROP TRIGGER tri_Sno

D.REMOVE TRIGGER tri_Sno

A、Create trigger trigger_del after delete on xs_kc for each row Delete from kc where xs_kc.kno=old.kno;

B、Create trigger trigger_del after delete on kc for each row Delete from xs_kc where xs_kc.kno=new.kno;

C、Create trigger trigger_del after delete on xs_kc for each row Delete from kc where xs_kc.kno=new.kno;

D、Create trigger trigger_del after delete on kc for each row Delete from xs_kc where xs_kc.kno=old.kno;

Create trigger命令用于创建()。

A.存储过程

B.触发器

C.视图

D.表

A、触发器是一种特殊的存储过程，用户可以直接调用

B、触发器可以用来定义比CHECT约束更复杂的规则

C、删除触发器可以用DROP TRIGGER命令，也可以用SSMS对象资源管理器

D、用DELETE语句删除记录激活触发器时，系统在原表删除记录的同时，会把删除的记录添加到deleted临时表。