请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是（ ）A.GRANT SELECT TO SC ON Wang WITH PUBLICB.GRANT SELECT ON SC TO Wang WITH PUBLICC.GRANT SELECT TO SC ON Wang WITH GRANT OPTIOND.GRANT SELECT ON SC TO Wang WITH GRANT OPTION
- 2.将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是（ ）A．GRANT SELECT TO SC ON Wang WITH PUBLICB．GRANT SELECT ON SC TO Wang WITH PUBLICC．GRANT SELECT TO SC ON Wang WITH GRANT OPTIOND．GRANT SELECT ON SC TO Wang WITH GRANT OPTION
- 3.将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是 ( )。 选项： A: GRANT SELECT TO SC ON Wang WITH GRANT OPTION B: GRANT SELECT ON SC TO Wang WITH PUBLIC C: GRANT SELECT ON SC TO Wang WITH GRANT OPTION D: GRANT SELECT TO SC ON Wang WITH PUBLIC
- 4.将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是——选项： A:GRANT SELECT TO SC ON Wang WITH PUBLIC; B:GRANT SELECT ON SC TO Wang WITH PUBLIC; C:GRANT SELECT TO SC ON Wang WITH GRANT OPTION; D:GRANT SELECT ON SC TO Wang WITH GRANT OPTION
- 5.将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是选项： A:GRANT SELECT TO SC ON Wang WITH PUBLIC; B:GRANT SELECT ON SC TO Wang WITH PUBLIC; C:GRANT SELECT TO SC ON Wang WITH GRANT OPTION; D:GRANT SELECT ON SC TO Wang WITH GRANT OPTION
- 6.【单选题】将查询 SC 表的权限授予用户 Wang,并允许该用户将此权限授予其他用户。实现此功 能的 SQL 语句是()。A. GRANT SELECT TO SC ON Wang WITH PUBLIC B. GRANT SELECT ON SC TO Wang WITH PUBLIC C. GRANT SELECT TO SC ON Wang WITH GRANT OPTION D. GRANT SELECT ON SC TO Wang WITH GRANT OPTION
- 7.将查询SC表的权限授予用户Wang,并允许该用户将此权限授予其他用户。实现此功能的SQL语句是( )。 选项： A:GRANT SELECT TO SC ON Wang WITH GRANT OPTION B:GRANT SELECT ON SC T0 Wang WITH PUBLIC C:GRANT SELECT ON SC TO Wang WITH GRANT OPTTON D:GRANT SELECT TO SC ON Wang WITH PUBLIC
- 8.将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。 A.GRANT SELECT TO SC U1 WITH PUBLICB.GRANT SELECT ON SC TO U1 WITH PUBLICC.GRANT SELECT TO SC ON U1 WITH GRANT OPTIOND.GRANT SELECT ON SC TO U1 WITH GRANT OPTION
- 9.将查询关系S的权限授予用户WANG,并允许该用户将此权限授予给其他用户,实现此功能的SQL语句是____。[br][/br] A.GRANT SELECT TO S ON WANG WITH PUBLIC;[br][/br] B.GRANT SELECT ON S TO WANG WITH PUBLIC;[br][/br] C.GRANT SELECT TO S ON WANG WITH GRANT OPTION;[br][/br] D.GRANT SELECT ON S TO WANG WITH GRANT OPTION;
- 10.将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现该功能的SQL语句是______。 选项： A、GRANT SELECT TO SC U1 WITH PUBLIC B、GRANT SELECT ON SC TO Ul WITH PUBLIC C、GRANT SELECT TO SC ON Ul WITH GRANT OPTION D、GRANT SELECT ON SC TO Ul WITH GRANT OPTION
- 11.将查询 SC 表的权限授予用户 U1，并允许该用户将此权限授予其他用户。实现此功能的SQL 语句是（ ）。选项： A:GRANT SELECT TO SC ON Ul WITH PUBIJIC; B:GRANT SELECT ON SC TO U1 WITH PUBLIC; C:GRANT SELECT TO SC ON Ul WITH GRANT OPTION; D:GRANT SEIECT ON SC TO U1 WITH GRANT OPTION
- 12.将查询 SC 表的权限授予用户 U1，并允许该用户将此权限授予其他用户。实现此功能的SQL 语句是（ ）。 选项： A、GRANT SELECT TO SC ON Ul WITH PUBIJIC B、GRANT SELECT ON SC TO U1 WITH PUBLIC C、GRANT SELECT TO SC ON Ul WITH GRANT OPTION D、GRANT SEIECT ON SC TO U1 WITH GRANT OPTION
- 13.将查询SC表的权限授予用户USER1，并允许该用户将此权限授予其他用户。此功能的SQL语句是（ ）。选项： A:GRANT SELECT TO SC ON USER1 WITH PUBLIC; B:GRANT SELECT ON SC TO USER1 WITH PUBLIC; C: GRANT SELECT TO SC ON USERl WITH GRANT OPTION ; D:GRANT SELECT ON SC TO USER1 WITH GRANT OPTION
- 14.将查询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
- 15.将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是（ ）。 选项： A、GRANT SELECT TO SC ON U1 WITH PUBLIC B、 GRANT SELECT ON SCTO U1 WITH PUBLIC C、 GRANT SELECT TO SC ON U1 WITH GRANT OPTION D、 GRANT SELECTONSCTOU1 WITH GRANT OPTION
- 16.下列SQL语句中，能够实现“将查询SC表的权限授予用户U1，并且允许该用户将此权限授予其他用户”这一功能的是（ ）。选项： A:GRANT SELECT TO SC ON U1 WITH PBULIC;; 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;
- 17.使用SQL语句把对SC表的查询权限和修改成绩权限授予用户U4，并允许将该权限授予其他用户，下列语句正确的是（）。 选项： A、GRANT SELECT,UPDATE(Grade) ON TABLE SC TO U4 WITH GRANT OPTION; B、GRANT SELECT,UPDATE(Grade) ON TABLE SC TO U4; C、GRANT SELECT,UPDATE ON TABLE SC TO U4 WITH GRANT OPTION; D、GRANT SELECT,UPDATE ON TABLE SC TO U4;
- 18.把对表sc的查询权限授予所有用户 选项： A:grant select on sc to all B:grant select on table sc to public C:grant select on sc to * D:grant * on sc to *
- 19.把对表sc的查询权限授予所有用户 选项： A、grant select on sc to * B、grant * on sc to * C、grant select on sc to all D、grant select on table sc to public
- 20.把对表sc的查询权限授予所有用户 选项： A:grant * on sc to * B:grant select on table sc to public C:grant select on sc to * D:grant select on sc to all
- 21.将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是
- 22.将对关系SC(sno,cno,grade)的查询和属性GRADE的修改权限授予用户Jack的SQL语句是 选项： A: grant select,update on sc to Jack,Rose B: grant select, update(grade) on sc to Jack and Rose C: grant select,update(grade) on sc to Jack,Rose D: grant select,update(grade) on sc to Jack,Rose with grant option
- 23.（单选题）将对关系SC(sno,cno,grade)的查询和属性GRADE的修改权限授予用户Jack的SQL语句是 选项： A:grant select,update on sc to Jack,Rose B:grant select, update(grade) on sc to Jack and Rose C:grant select,update (grade) on sc to Jack,Rose D:grant select, update (grade) on sc to Jack, Rose with grant option
- 24.【单选题】将对关系SC(sno,cno,grade)的查询和属性GRADE的修改权限授予用户Jack的SQL语句是（ ）。 选项： A:grant select, update(grade) on sc to Jack and Rose B:grant select,update(grade) on sc to Jack,Rose C:grant select,update on sc to Jack,Rose D:grant select,update(grade) on sc to Jack,Rose with grant option
