网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
删除触发器tri—Sno的正确命令是——。
A．REMOVE TRIGGER tri—Sno
B．DROP TRIGGER tri—Sno
C．TRUNCATE FRIGGER tri—Sno
D．DELETE TRIGGER tri—Sno
参考答案
更多 “ 删除触发器tri—Sno的正确命令是——。A．REMOVE TRIGGER tri—SnoB．DROP TRIGGER tri—SnoC．TRUNCATE FRIGGER tri—SnoD．DELETE TRIGGER tri—Sno ” 相关考题
考题
在SQL Server 2000中，有商品表(商品号，商品名，单价)和销售表(商品号，销售时间，销售价格)。现要限制“销售价格”的取值必须在此商品“单价”的0.6倍到1.5倍范围之内，实现这个约束的正确代码是______。A．CHECK(销售价格BETWEEN单价*0.6 AND单价*1.5)B．CHECK(销售价格BETWEEN商品表.单价*0.6 AND商品表.单价*1.5)C．CREATE TRIGGER tri_Sales ON销售表FOR INSERT，UPDATE AS IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b ON a.商品号=b.商品号 WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5) ROLLBACKD．CREATE TRIGGER tri_Sales ON销售表INSTEAD OF INSERT，UPDATE AS IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b ON a.商品号=b.商品号 WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5) ROLLBACK
考题
下列关于触发器的说法,正确的是()。
A、后触发型触发器是在触发器执行完成后再执行引发触发器执行的语句B、触发器是由数据更改操作引发的自动执行的代码C、引发触发器执行的操作可以是SELECTD、CREATE TRIGGER tri ON table1 FOR INSERT定义的是前触发型触发器
考题
如果要从数据库中删除触发器，应该使用SQL语言的命令()。A.DELETE TRIGGERB.DROP TRIGGERC.REMOVE TRIGGERD.DISABLE TRIGGER
考题
AcustomerhasfourAIXpartitionsthatrequireaSAN.ThedisksubsystemmustreplicatetoaremotesiteviaanIPnetwork.EachsitehastwoCiscoMDS9509directorswithfibrechannellinecards.WhichofthefollowingmustbeaddedtoeachdirectortomeettheIPrequirement？（）A.tri-rateSFPB.updatetothelatestCiscoIOSC.FCIPactivationontheexisting16FClinecardsD.MultiprotocolServicesModulewithFCIPactivation
考题
设在SQL Server 2008中有如下定义触发器的语句:CREATE TRIGGER tri ON T1 INSTEAD OF INSERT AS……下列关于该触发器执行机制的说法,正确的是( )。
A.当在T1表上执行INSERT操作时，先执行INSERT操作，然后再执行tri触发器B.当在T1表上执行INSERT操作时，只执行tri触发器，而不实际执行INSERT操作C.当在T1表上执行INSERT操作时，先执行tri触发器，然后再实际执行INSERT操作D.当在T1表上执行INSERT操作时，先执行INSERT操作，如果操作正确，则无需执行tri触发器
考题
WhataretwobenefitsofclusteredaccesspointsonasmallbusinessnetworkusingtheCisco500SeriesAccessPoint?()
A.CiscoIOSconfigurationB.tri-band11gsingleradiosC.rougeAPintegrationD.singleviewtodeployandmanageE.secureguestaccess
考题
设在SC（Sno，Cno，Grade）表上定义了触发器： CREATE TRIGGER tri1 ON SC AFTER INSERT … 当执行语句：INSERT INTO SC VALUES（’s001’， ’c01’，90） 会引发该触发器执行。下列关于触发器执行时表中数据的说法，正确的是（）。ASC表和INSERTED表中均包含新插入的数据BSC表和INSERTED表中均不包含新插入的数据CSC表中包含新插入的数据，INSERTED表中不包含新插入的数据DSC表中不包含新插入的数据，INSERTED表中包含新插入的数据
考题
以下触发器是当对[employee表]进行（）操作时触发。Create Trigger abc on employeeFor insert，update，deleteAs⋯⋯A、只是修改B、只是插入C、只是删除D、修改、插入、删除
考题
单选题The cooperative announced last week that due to increasing sales in the tri-county area, it would distribute a quarterly dividend of more than twice the usual amount to all of its members.A
The cooperative announced last week that due to increasing sales in the tri-county areaB
The cooperative announced that due to increasing sales last week in the tri-county areaC
Last week, the cooperative announced that due to sales increasing on a tri-county basisD
Last week, the cooperative, which announced increasing sales in the tri-county areaE
Due to increasing sales in the tri-county area the cooperative announced last week
考题
单选题如果要从数据库中删除触发器，应该使用SQL语言的命令（）。A
DELETE TRIGGERB
DROP TRIGGERC
REMOVE TRIGGERD
DISABLE TRIGGER
考题
单选题以下触发器是当对[employee表]进行（）操作时触发。Create Trigger abc on employeeFor insert，update，deleteAs⋯⋯A
只是修改B
只是插入C
只是删除D
修改、插入、删除
考题
判断题BSC中用来进行话音代码转换的单元是TRI。A
对B
错
热门标签
最新试卷