把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是

A.GRANT GRADE ON SC TO ZHAO

B.GRANT UPDATE ON SC TO ZHAO

C.GRANT UPDATE ON SC (GRADE) TO ZHAO

D.GRANT UPDATE (GRADE) ON SC TO ZHAO

A.GRANT GRADE ON SC TO Kate

B.GRANT UPDATE ON SC TO Kate

C.GRANT UPDATE (GRADE) ON SC TO Kate

D.GRANT UPDATE ON SC (GRADE) TO Kate

A.GRANT GRADE ON SC TO Kate

B.GRANT UPDATE ON SC TO Kate

C.GRANT UPDATE (GRADE) ON SC TO Kate

D.GRANT UPDATE ON SC (GRADE) TO Kate

A.ПSNAME, GRADE (σCNAME=’数据库技术’(C) ¥SC ¥ПSNO, SNAME (S) )###SXB###B.ПSNAME, GRADE (σCNAME=’数据库技术’(C) ¥ SC ¥ S)###SXB###C.ПSNAME, GRADE (C ¥ SC ¥ SC)###SXB###D.ПSNAME, GRADE (σCNAME=’数据库技术’ (ПCNO, CNAME (C)) ¥ПSNO, CNO, GRADE (SC) ¥ПSNO, SNAME (S) )

A.SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞=ALL (SELECT Grade FROM SC WHERE Cno=’C1’);

B.SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN (SELECT Grade FROM SC WHERE Cno=’C1’);

C.SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞ ANY (SELECT Grade FROM SC WHERE Cno=’C1’);

D.SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞= (SELECT Grade FROM SC WHERE Cno=’C1’);

A.UPDATE SC SET Grade=Grade*1.1 WHERE Cno=’DB’ AND Grade BETWEEN 60 AND 70;

B.UPDATE SC SET Grade+=Grade*0.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade ＞= 60 AND Grade ＜=70;

C.UPDATE SC SET Grade=Grade*1.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade ＜= 60 AND Grade ＞=70;

D.UPDATE SC SET Grade=Grade*1.1 WHERE Cno IN (Select Cno From Course WHERE Cname=’DB’) AND Grade BETWEEN

A.SELECT SNO FROM S, SC WHERE S.SNO=SC.SNO AND CNO=’C01’AND GRADE＞90 AND SEX=’男’;

B.SELECT SNO FROM S WHERE SEX=’男’AND SNO IN (SELECT SNO FROM SC WHERE CNO=’C01’AND GRADE＞90) ;

C.SELECT SNO FROM SC WHERE CNO=’C01’AND GRADE＞90 EXCEPT SELECT SNO FROM S WHERE SEX=’女’;

D.SELECT SNO FROM S WHERE SEX=’男’ EXCEPT SELECT SNO FROM SC WHERE CNO=’C01’AND GRADE＞90 ;

A.GRANT 成绩 ON 比赛 TO 李勇;

B.GRANT UPDATE(成绩) ON 比赛 TO '李勇' WITH GRANT OPTION;

C.GRANT UPDATE (成绩) ON 比赛 TO 李勇 WITH GRANT OPTION;

D.GRANT UPDATE ON 比赛 (成绩) TO 李勇;

A.GRANT 成绩 ON 比赛 TO 李勇;

B.GRANT UPDATE(成绩) ON 比赛 TO '李勇' WITH GRANT OPTION;

C.GRANT UPDATE (成绩) ON 比赛 TO 李勇 WITH GRANT OPTION;

D.GRANT UPDATE ON 比赛 (成绩) TO 李勇;