题目内容

创建表tb_account，并在表上建立触发器，代码如下：CREATETABLEtb_account(numINT,amountDECIMAL(10,2));CREATETRIGGERtr_acctAFTERINSERTONtb_accountFOREACHROWSET@sum=@sum+NEW.amount;以上代码执行成功后，tb_account表上不能再建立的触发器类型是（）。

AFTER INSERT
BEFORE INSERT
C. AFTER UPDATE
D. AFTER DELETE

查看答案

搜索结果不匹配？点我反馈

更多问题

设有学生表student，包含的属性有学号sno、学生姓名sname、性别sex、年龄age、所在专业smajor下列语句正确的是（）。

A. SELECT sno, sname FROM student ORDER BY sname Union SELECT sno, sname FROM student WHERE smajor='CS';
B. SELECT sno, sname FROM student WHERE sex=’M’ Union SELECT sno, sname, sex FROM student WHERE smajor='CS';
C. SELECT sno, sname FROM student WHERE sex='M' ORDER BY sname Union SELECT sno, sname FROM student WHERE smajor='CS';
D. SELECT sno, sname FROM student WHERE sex='M' Union SELECT sno, sname FROM student WHERE smajor ='CS' ;

查看答案