删除触发器tri—Sno的正确命令是——。
A: REMOVETRIGGERtri—Sno
B: DROPTRIGGERtri—Sno
C: TRUNCATEFRIGGERtri—Sno
D: DELETETRIGGERtri—Sno
A: REMOVETRIGGERtri—Sno
B: DROPTRIGGERtri—Sno
C: TRUNCATEFRIGGERtri—Sno
D: DELETETRIGGERtri—Sno
举一反三
- 下列查询语句中，错误的是（）。 A: ASELECT Sno， COUNT（*） FROM SC GROUP BY Sno B: BSELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*）> 3 C: CSELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*）> 3 D: DSELECT Sno FROM SC GROUP BY Sno
- 下列查询语句中，错误的是（）。 A: SELECT Sno， COUNT（*） FROM SC GROUP BY Sno B: SELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*）> 3 C: SELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*）> 3 D: SELECT Sno FROM SC GROUP BY Sno
- 如果在“学生-课程”数据库中，希望当删除Student表中的元组时，级联删除SC表中相应的元组，则在定义SC表时，应有语句____________________。 A: FOREIGN KEY (Sno) ON DELETE CASCADE Student(Sno) B: FOREIGN KEY (Sno) ON DELETE NO ACTION Student(Sno) C: FOREIGN KEY (Sno) REFERENCES Student(Sno) ON DELETE NO ACTION D: FOREIGN KEY (Sno) REFERENCES Student(Sno) ON DELETE CASCADE
- 查询选课门数大于3门的同学学号，姓名, 选课门数Select ______________from student s, scwhere s.sno=sc.sno group by __________having _____________ A: sno, sname, count(*) ; sno, sname; count(*)>3 B: sno, sname, count(*) ; sno; count(*)>3 C: sno, sname, count(cno) ; sno; count(cno)>3 D: sno, sname, count(sno) ; sno; count(sno)>3
- 下列SQL语句中，_________可以在“学生-课程”数据库正确实现“将学生的学号及他的平均成绩定义为一个视图”。 A: CREAT VIEW S_G(Sno，Gavg) AS SELECT Sno，AVG(Grade) FROM SCGROUP BY Sno； B: CREAT VIEW S_G(Sno，AVG(Grade)) AS SELECT Sno，AVG(Grade) FROM SCGROUP BY Sno； C: CREAT VIEW S_G AS SELECT Sno，AVG(Grade) FROM SCGROUP BY Sno； D: CREAT VIEW S_G(Sno，Gavg) AS SELECT Sno，AVG(Grade) FROM SCORDER BY Sno；