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 update on Emp TO LIU WITH CHECK OPTION
B.GRANT update(empname)on Emp TO LIU WITH CHECK OPTION
C.GRANT update on Emp TO LIU WITH GRANT OPTION
D.GRANT update(empname)on Emp TO LIU WITH GRANT OPTION
第2题
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 李勇;
第3题
(48)
A. GRANT update on Emp TO LIU WITH CHECK OPTION
B. GRANT update(empname) on Emp TO LIU WITH CHECK OPTION
C. GRANT update on Emp TO LIU WITH GRANT OPTION
D. GRANT update(empname) on Emp TO LIU WITH GRANT OPTION
第4题
A.REVOKE UPDATE (XH) ON TABLE FROM USER4;
B.REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;
C.REVOKE UPDATE (XH) ON TABLE STUD FROM USER4;
D.REVOKE ALL PRIVILEGES ON TABLE STUD FROM USER4;
第6题
S(S#, SNAME, SEX, AGE),
SC(S#, C#, GRADE),
C(C#, CNAME, TEACHER)
它们的主码分别是S#, (S#, C#)和C#
把对SC表的查询和修改成绩的权限授给用户user1的SQL语句,正确的是( )。
A) GRANTUPDATE(GRADE), SELECTTO user1 ONTABLE SC;
B) GRANT UPDATE(GRADE), SELECT ON TABLE SC TO user1;
C) GRANT UPDATE TABLE SC ON(GRADE), SELECT TO user1;
D) GRANTON TABLE SCUPDATE(GRADE), SELECT TO user1;
A.
B.
C.
D.
第9题
B.CASCADE
C.WITH GRANT OPTION
D.WITH CHECK OPTION
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!