题目内容
(请给出正确答案)
[单选题]
下列SQL语句中,能够实现“给用户teacher授予查询SC的权限”这一功能的是()。
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
查看答案
如果结果不匹配,请 联系老师 获取答案
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
A.DROP PROC CountProc1;
B.DELETE PROC CountProc1;
C.DROP PROCEDURE CountProc1;
D.DELETE PROCEDURE CountProc1;
A.SQL语句中使用了ORDERBY子句
B.SQL语句中使用了join运算上非第一个表中的列,语句中包含GROUPBY子句
C.使用了SQL_SMALL_RESULT选项
D.DISTINCT和GROUPBY一起使用