ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-042

047-042

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-17 09:58:34 0 删除 编辑
42. SCOTT is a user in the database.
Evaluate the commands issued by the DBA:
1 -CREATE ROLE mgr.
2 -GRANT CREATE TABLE, SELECT ON oe.orders TO mgr.
3 -GRANT mgr, create table TO SCOTT.
Which statement is true regarding the execution of the above commands?
A. Statement 1 would not execute because the WITH GRANT option is missing.
B. Statement 1 would not execute because the IDENTIFIED BY clause
is missing.
C. Statement 3 would not execute because role and system privileges cannot
be granted together in a single GRANT statement.
D. Statement 2 would not execute because system privileges and object
privileges cannot be granted together in a single GRANT command.
Answer: D

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718810/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-040
下一篇: 047-043
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214041