OCP认证052考试最新题库及答案整理-52

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