将对关系SC的属性GRADE的修改权限授予用户Kate的SQL语句是()。
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
第1题
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
第2题
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
第5题
第6题
第9题
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 ;
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!