‍假定用户WangPing创建了表RecipeDetail, Medicine, RecipeMaster,并且WangPing执行如下授权

1.假定用户WangPing创建了表RecipeDetail, Medicine, RecipeMaster,并且WangPing执行如下授权命令：GRANT SELECT ON RecipeDetail TO LiXia；GRANT SELECT ON RecipeMaster TO LiXia WITH GRANT OPTION；GRANT UPDATE（Mprice） ON Medicine TO WangHao；GRANT REFERENCE（Mno）ON Medicine TO ZhangYang；GRANT INSERT，DELETE ON RecipeDetail TO MengFan WITH GRANT OPTION；以下哪个是错误的选项： A:LiXia能够对RecipeDetail和RecipeMaster执行查询语句; B:LiXia能将RecipeMaster的查询权限授予DengTian; C:WangHao能够修改Medicine表中的Mprice列的值; D:WangHao能够执行UPDATE Medicine SET Mprice = Mprice-10

2.‍假定用户WangPing创建了表RecipeDetail, Medicine, RecipeMaster,并且WangPing执行如下授权命令：‍GRANT SELECT ON RecipeDetail TO LiXia；‍GRANT SELECT ON RecipeMaster TO LiXia WITH GRANT OPTION；‍GRANT UPDATE（Mprice） ON Medicine TO WangHao；‍GRANT REFERENCE（Mno）ON Medicine TO ZhangYang；‍GRANT INSERT，DELETE ON RecipeDetail TO MengFan WITH GRANT OPTION；‍‍以下哪个是错误的‍ 选项： A、LiXia能够对RecipeDetail和RecipeMaster执行查询语句 B、LiXia能将RecipeMaster的查询权限授予DengTian C、WangHao能够修改Medicine表中的Mprice列的值 D、WangHao能够执行UPDATE Medicine SET Mprice = Mprice-10

3.‍假定用户WangPing创建了表RecipeDetail, Medicine, RecipeMaster,并且WangPing执行如下授权命令：‌GRANT SELECT ON RecipeDetail TO LiXia；‌GRANT SELECT ON RecipeMaster TO LiXia WITH GRANT OPTION；‌GRANT UPDATE（Mprice） ON Medicine TO WangHao；‌GRANT REFERENCE（Mno）ON Medicine TO ZhangYang；‌GRANT INSERT，DELETE ON RecipeDetail TO MengFan WITH GRANT OPTION；‌‍以下哪个是错误的‌ 选项： A、LiXia能够对RecipeDetail和RecipeMaster执行查询语句 B、LiXia能将RecipeMaster的查询权限授予DengTian C、WangHao能够修改Medicine表中的Mprice列的值 D、WangHao能够执行UPDATE Medicine SET Mprice = Mprice-10

4.能够执行INSERT INTO RecipeDetail(Mno) SELECT Mno FROM Medicine WHERE Mname LIKE '%替硝唑%' 语句，下面哪个说法是错误的——选项： A:需要一个RecipeDetail 表上的INSERT权限; B:RecipeDetail表上仅需要INSERT（Mno）权限; C:需要一个对Medicine关系表的SELECT授权; D:SELECT授权可以只针对Medicine中的Mno属性

5.能够执行INSERT INTO RecipeDetail(Mno) SELECT Mno FROM Medicine WHERE Mname LIKE '%替硝唑%' 语句，下面哪个说法是（）错误的？选项： A:需要一个RecipeDetail 表上的INSERT权限; B:RecipeDetail表上仅需要INSERT（Mno）权限; C:需要一个对Medicine关系表的SELECT授权; D:SELECT授权可以只针对Medicine中的Mno属性

6.能够执行INSERT INTO RecipeDetail(Mno) SELECT Mno FROM Medicine WHERE Mname LIKE '%替硝唑%' 语句，下面哪个说法是——错误的？选项： A:需要一个RecipeDetail 表上的INSERT权限; B:RecipeDetail表上仅需要INSERT（Mno）权限; C:需要一个对Medicine关系表的SELECT授权; D:SELECT授权可以只针对Medicine中的Mno属性

7.使用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;

8.（单选题）将对关系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

9.将查询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

10.下列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;

11.将查询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

12.将对关系SC(sno,cno,grade)的查询和属性GRADE的修改权限授予用户Jack和Rose的SQL语句是（）选项：A、grant select,update on sc to Jack,RoseB、grant select, update(grade) on sc to Jack and RoseC、grant select,update(grade) on sc to Jack,RoseD、grant select,update(grade) on sc to Jack,Rose with grant option

13.数据库中Sailors表是由joe创建的，在DBMS完成下面的语句后 1.GRANT SELECT ON TABLE Sailors TO Art WITH GRANT OPTION —Joe执行 2.GRANT SELECT,UPDATE ON TABLE Sailors TO Bob WITH GRANT OPTION —Joe执行 3.GRANT SELECT ON TABLE Sailors TO Bob WITH GRANT OPTION —Art执行 4.REVOKE SELECT ON TABLE Sailors FROM Art CASCADE —Joe执行 Bob对表Sailors拥有【】。选项： A、SELECT权 B、UPDATE权 C、没有任何权限 D、SELECT和UPDATE权

14.将查询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

15.将查询 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

16.将查询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

17.[单选题]将查询关系S的权限授予用户WANG，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是（） A GRANT SELECT TO S ON WANG WITH PUBLIC B GRANT SELECT ON S TO WANG WITH PUBLIC C GRANT SELECT TO S ON WANG WITH GRANT OPTION D GRANT SELECT ON S TO WANG WITH GRANT OPTION

18.将查询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

19.将查询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

20.将查询SC表得权限授予用户Wang,并允许该用户将此权限授予其她用户。实现此功能得SQL语句就是( )A、GRANT SELECT TO SC ON Wang WITH PUBLICB、GRANT SELECT ON SC TO Wang WITH PUBLICC、ON Wang WITH GRANT OPTIOND、GRANT SELECT ON SC TO Wang WITH GRANT OPTION

21.将查询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

22.将查询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

23.将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。选项： A．GRANT SELECT TO SC 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