52、In one of your databases:
1. USER1 and USER2 have no system privileges.
2. ROLE1 only has these privileges:
* create session
* create table
* create view
Examine these commands:
SQL> conn / as sysdba
Connected.
SQL> GRANT create table,role1 TO user1 WITH ADMIN OPTION;
GRant successded.
SQL> conn user1/oracle_4U
Connected.
SQL> GRANT role1 TO user2;
Grant successded.
Which command would you execute and as which user, to revoke the create table privilege from USER2?
• A. Revoke create table from user2 as user1
• B. Revoke create table from user1 as sys
• C. Revoke create table from role1 as user1
• D. Revoke create table from role1 as sys
• E. Revoke create table from user2 as sys
• Correct Answer: D
北京CUUG整理,转载请注明,OCP讨论群:569933648/836361015
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31550393/viewspace-2214093/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31550393/viewspace-2214093/