题目内容
（请给出正确答案）
A.GRANT SELECT on SC to teacher
B.REVOKE SELECT on SC to teacher
C.GRANT SELECT on TABLE to teacher
D.REVOKE SELECT on TABLE to teacher
如果结果不匹配，请 联系老师 获取答案
更多“下列SQL语句中，能够实现“给用户teacher授予查询SC…”相关的问题
A.DROP PROC CountProc1;
B.DELETE PROC CountProc1;
C.DROP PROCEDURE CountProc1;
D.DELETE PROCEDURE CountProc1;
A.SELECT姓名FROMSWHEREEXISTS(SELECT*FROMSCWHERE学号=学号AND课程号='C2')
B.SELECT姓名FROMSWHERE学号IN(SELECT学号FROMSCWHERE课程号='C2')
C.SELECT姓名FROMSINNERJOINSCON学号=sc.学号WHERE课程号='C2'
D.SELECT姓名FROMSWHERE学号=(SELECT学号FROMSCWHERE课程号='C2)
A.select*fromt_studentorderbyscorelimit100
B.select*fromt_studentorderbyscore
C.selectname,scoreaspfromt_studentorderbyplimit100
D.selectname,scoreassfromt_studentorderbyscorelimit100
