Oracle 11G OCP 1Z0-052 157

（157）Examine the commands executed in the following sequence:

1: SQL> CREATE ROLE mgrrole;

2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;

3: SQL> GRANT select,update ON sh.sales TO mgrrole;

4: SQL> CREATE ROLE ceo IDENTIFIED BY boss;

5: SQL> GRANT mgrrole,drop any table,create any directory TO ceo;

6: SQL> GRANT ceo TO mgrrole;

Which statement is true about the above commands?

A. The commands execute successfully.

B. Command 6 produces an error because of circular role grant.

C. Command 5 produces an error because a role cannot be granted to another role.

D. Command 3 produces an error because the MGRROLE role already contains system privileges.

答案：（B）

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

转载于:http://blog.itpub.net/17013648/viewspace-1224983/