数据库中SAILORS表是由joe创建的.在DBMS完成下面的语句后Grant select on Sailors To Art With Grant option...Joe执行Grant select,update on Sailors To Bob With Grant option...Joe执行Grant select on Sailors To Bob With Grant option...Art执行Revoke select on Sailors From Art Cascade...Joe执行Bob对Sailors表拥有[1分]
举一反三
- 将查询SC表的权限授予用户U1,并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。 A: A) GRANT SELECT TO SC U1 WITH PUBLIC B: B) GRANT SELECT ON SC TO U1 WITH PUBLIC C: C) GRANT SELECT TO SC ON U1 WITH GRANT OPTION D: D) GRANT SELECT ON SC TO U1 WITH GRANT OPTION
- 关系模式Sailors(sid,lastname.firtname,age,ratring),其中lastname允许为空. 下面哪个语句能够查找出lastname属性值不为空的水手信息. A: SELECT * FROM SAILORS WHERE LASTNAME<>’NULL’ B: SELECT * FROM SAILORS WHERE LASTNAME<>NULL C: SELECT * FROM SAILORS WHERE LASTNAME IS not NULL D: SELECT * FROM SAILORS WHERE LASTNAME not LIKE ’NULL’
- 将查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。 A: GRANT SELECT TO TABLE SC ON U1 WITH PUBLIC B: GRANT SELECT ON TABLE SC TO U1 WITH PUBLIC C: GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTION D: GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
- 把对S表查询权限、插入记录权限授权给U1,正确的SQL语句是()。 A: Grant SelectinsertonStoU1 B: Grant Select,insertonStoU1 C: Grant Update(姓名)onStoU1with grant option D: Grant Update(姓名)onStoU1
- 下列SQL语句中,能够实现“将查询SC表的权限授予用户U1,并允许该用户将此权限授予其他用户”这一功能的是( ) A: GRANT SELECT TO SC ON U1 WITH PUBLIC B: GRANT SELECT ON SC TO U1 WITH PUBLIC C: GRANT SELECT TO SC ON U1 WITH GRANT OPTION D: GRANT SELECT ON SC TO U1 WITH GRANT OPTION