Oracle 11G OCP 1Z0-052 155
(155)The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:
答案:(C)
SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;
The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;
Now, the user HR decides to revoke privileges from JIM using this command: SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim;
Which statement is true after HR issues the REVOKE command?
A.The command fails because SCOTT still has privileges.
B.The command succeeds and privileges are revoked from JIM.
C.The command fails because HR cannot revoke the privileges from JIM.
D.The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.答案:(C)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1224981/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 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
- Oracle 11G OCP 1Z0-052 65Oracle