网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
SQL语言的GRANT和REVOKE语句主要用来实现()
A.数据库的安全性
B.并发控制
C.数据库的完整性
D.数据库的可靠性
参考答案和解析
C
更多 “SQL语言的GRANT和REVOKE语句主要用来实现()A.数据库的安全性B.并发控制C.数据库的完整性D.数据库的可靠性” 相关考题
考题
20 ) 下列 SQL 语句中 , 能够实现 “ 收回用户 WANG 对学生表 ( STUDENT ) 中学号 ( XH ) 的修改权 ” 这一功能的是A ) GRANT UPDATE ( XH ) ON STUDENT TO WANGB ) GRANT UPDATE ( XH ) ON TABLE TO WANGC ) REVOKE UPDATE ( XH ) ON STUDENT FROM WANGD ) REVOKE UPDATE ( XH ) ON TABLE TO WANG
考题
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
考题
下列SQL语句中,能够实现“收回用户WANG对学生表(STUDENT)中学号(XH)的修改权”这一功能的是( )。A.GRANT UPDATE(XH) ON STUDENT TO WANGB.GRANT UPDATE(XH) ON TABLE TO WANGC.REVOKE UPDATE(XH) ON STUDENT FROM WANGD.REVOKE UPDATE(XH) ON TABLE FROM WANG
考题
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A
Alice onlyB
Alice and ReenaC
Alice, Reena, and TimberD
Sue, Alice, Reena, and Timber
热门标签
最新试卷