【正确答案】①SELECT Sname,Sage FROM Student WHERE Sage<ANY(SELECT Sage FROM Student WHERE Sdept='CS') AND Sdept<>'CS' ②CREATE VIEW IS_S1(Sno,Sname,Grade) AS SELECT Student.Sno,Sname,Grade FROM Student,SC WHERE Sdept='IS' AND Student.Sno=SC.Sno AND SC.Cno='1'; ③CREATE TRIGGER Print_f AFTER INSERT ON Student FOR EACH ROW AS BEGIN IF(new.Grade<60)THEN PRINT'不及格' END IF END;
【答案解析】[解析] 创建视图用CTREATE VIEW,而创建触发器是用CREATE TRIGGER,触发器分为行级触发器和语句级触发器,FOR EACH ROW是行级触发器。