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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11G OCP 1Z0-053 157Oracle
- Oracle 11G OCP 1Z0-052 14Oracle
- Oracle 11G OCP 1Z0-052 88Oracle
- Oracle 11G OCP 1Z0-052 89Oracle
- Oracle 11G OCP 1Z0-052 90Oracle
- Oracle 11G OCP 1Z0-052 92Oracle
- Oracle 11G OCP 1Z0-052 93Oracle
- Oracle 11G OCP 1Z0-052 94Oracle
- Oracle 11G OCP 1Z0-052 95Oracle
- Oracle 11G OCP 1Z0-052 96Oracle
- Oracle 11G OCP 1Z0-052 97Oracle
- Oracle 11G OCP 1Z0-052 98Oracle
- Oracle 11G OCP 1Z0-052 99Oracle
- Oracle 11G OCP 1Z0-052 71Oracle
- Oracle 11G OCP 1Z0-052 73Oracle
- Oracle 11G OCP 1Z0-052 74Oracle
- Oracle 11G OCP 1Z0-052 75Oracle
- Oracle 11G OCP 1Z0-052 76Oracle
- Oracle 11G OCP 1Z0-052 77Oracle
- Oracle 11G OCP 1Z0-052 78Oracle
- Oracle 11G OCP 1Z0-052 79Oracle
- Oracle 11G OCP 1Z0-052 80Oracle
- Oracle 11G OCP 1Z0-052 81Oracle
- Oracle 11G OCP 1Z0-052 82Oracle
- Oracle 11G OCP 1Z0-052 83Oracle
- Oracle 11G OCP 1Z0-052 84Oracle
- Oracle 11G OCP 1Z0-052 85Oracle
- Oracle 11G OCP 1Z0-052 87Oracle
- Oracle 11G OCP 1Z0-052 53Oracle
- Oracle 11G OCP 1Z0-052 54Oracle
- Oracle 11G OCP 1Z0-052 57Oracle
- Oracle 11G OCP 1Z0-052 58Oracle
- Oracle 11G OCP 1Z0-052 59Oracle
- Oracle 11G OCP 1Z0-052 60Oracle
- Oracle 11G OCP 1Z0-052 61Oracle
- Oracle 11G OCP 1Z0-052 62Oracle
- Oracle 11G OCP 1Z0-052 63Oracle
- Oracle 11G OCP 1Z0-052 64Oracle