请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1."数据库中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表拥有" 选项：select权#chuwen#Update权#chuwen#没有任何权利#chuwen#select和Update权
- 2.将对关系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
- 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.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是A、GRANT GRADE ON SC TO ZHAOB、GRANT UPDATE ON SC TO ZHAOC、GRANT UPDATE (GRADE) ON SC TO ZHAOD、GRANT UPDATE ON SC (GRADE) TO ZHAO
- 5.假定用户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
- 6.将对关系SC的属性GRADE的修改权限授予用户Kate的SQL语句是（）。 选项： 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
- 7.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是 。(0.5) 选项： A、GRANT GRADE ON SC TO ZHAO B、GRANT UPDATE ON SC TO ZHAO C、GRANT UPDATE (GRADE) ON SC TO ZHAO D、GRANT UPDATE ON SC (GRADE) TO ZHAO
- 8.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是 。 选项： A:GRANT GRADE ON SC TO ZHAO; B:GRANT UPDATE ON SC TO ZHAO; C:GRANT UPDATE ON SC (GRADE) TO ZHAO; D:GRANT UPDATE (GRADE) ON SC TO ZHAO
- 9.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是（ ）选项： A:GRANT UPDATE ON SC (GRADE) TO ZHAO B:GRANT UPDATE ON SC TO ZHAO C:GRANT UPDATE (GRADE) ON SC TO ZHAO D:GRANT GRADE ON SC TO ZHAO
- 10.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是（）。 选项： A、grant update on sc(grade) to zhao B、grant grade on sc to zhao C、grant update on sc to zhao D、grant update(grade) on sc to zhao
- 11.将对关系SC的属性GRADE的修改权限授予用户Kate的SQL语句是（ ）。 选项： 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
- 12.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是（）选项： A:GRANT GRADE ON SC TO ZHAO; B:GRANT UPDATE ON SC TO ZHAO; C:GRANT UPDATE (GRADE) ON SC TO ZHAO; D:GRANT UPDATE ON SC (GRADE) TO ZHAO
- 13.把对关系SC的属性GRADE的修改权限授予用户ZHAO的SQL语句是 选项： A、GRANT GRADE ON SC TO ZHAO B、 GRANT UPDATE ON SC TO ZHAO C、 GRANT UPDATE(GRADE) ON SC TO ZHAO D、 GRANT UPDATE ON SC(GRADE) TO ZHAO
- 14.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是（ ） 选项： A:GRANT UPDATE ON SC (GRADE) TO ZHAO B:GRANT UPDATE ON SC TO ZHAO C:GRANT GRADE ON SC TO ZHAO D:GRANT UPDATE (GRADE) ON SC TO ZHAO
- 15.把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是（） 选项： A: GRANT UPDATE ON SC TO ZHAO B: GRANT UPDATE ON SC (GRADE) TO ZHAO C: GRANT UPDATE (GRADE) ON SC TO ZHAO D: GRANT GRADE ON SC TO ZHAO
