以下定义的4个视图中，能够进行更新操作的是_________。
A. CREATE VIEW S_G(学号,姓名,课程名,分数) AS SELECT S.学号,姓名,课程名,分数 FROM student S,score SC,course C WHERE S.学号=S学号AND S课程号 = 课程号;
B. CREATE VIEW S_AVG(学号,平均分) AS SELECT 学号,AVG(分数) FROM scoreWHERE 分数IS NOT NULL GROUP BY 学号;
CREATE VIEW S_MALE(学号,姓名) AS SELECT 学号,姓名 FROM student WHERE 班号='09031';
D. CREATE VIEW S_FEMALE(姓名,出生日期) AS SELECT 姓名,出生日期 FROM student WHERE 性别='女';
已知选课关系SC(Sno char(8), Cno char(8), GRADE integer)，Sno学号，Cno课程号，GRADE成绩。检索选修4门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩的降序排列出来。正确的SELECT语句是_________。
A. SELECT Sno,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 and COUNT(*)>=4 GROUP BY Sno ORDER BY Sgrade DESC;
B. SELECT Sno,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY Sno HAVING COUNT(*)>=4 ORDER BY Sgrade;
C. SELECT Sno,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY Sno ORDER BY Sgrade DESC;
D. SELECT Sno,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY SnoHAVING COUNT(*)>=4 ORDER BY Sgrade DESC;
已知选课关系SC(Sno char(8), Cno char(8), GRADE integer)，Sno学号，Cno课程号，GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是_________。
A. SELECT Sno FROM SC WHERE Cno='C2' AND GRADE >= ALL(SELECT GRADE FROM SC WHERE Cno='C2');
B. SELECT Sno FROM SC WHERE Cno='C2' AND GRADE IN (SELECT GRADE FROM SCWHERE Cno='C2');
C. SELECT Sno FROM SC WHERE Cno='C2' AND GRADE >=(SELECT GRADE FROM SCWHERE Cno='C2');
D. SELECT Sno FROM SC WHERE Cno='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE Cno='C2');
已知如下关系：学生Student(Sno, Sname)，课程Course(Cno, Cname, Tno)，选课SC(Sno, Cno, Score)，教师T(Tno, Tname)。其中Sno为学号，Sname为学生命名，Cno为课号，Cname为课程名，Tno为教师编号，Score为成绩，Tname为教师名。阅读SQL语句：SELECT Sname FROM Student WHERE Sno NOT IN(SELECT Sno FROM SC WHERE Student.Sno=SC.Sno and Cno= ‘C01’ and Score>=60)；关于其查询结果，下列说法正确的是_____。
A. C01号课程及格的所有学生的姓名
B. C01号课程不及格的所有学生的姓名
C. 剔出掉C01号课程及格学生的其他学生的姓名
D. 剔出掉C01号课程不及格学生的其他学生的姓名
微信支付 
支付宝支付