Question: This question refers to Oracle Database 12c. Examine these statements: Connect as sysdba Connected. GRANT CREATE USER TO hr WITH ADMIN OPTION; Grant succeeded. GRANT

This question refers to Oracle Database 12c.

question.PNG 

Examine these statements: Connect as sysdba Connected. GRANT CREATE USER TO hr WITH ADMIN OPTION; Grant succeeded. GRANT CREATE USER To john; Grant succeeded. Connect hr/hr@PROD Connected. GRANT CREATE USER TO alice WITH ADMIN OPTION; Grant succeeded. connas sysdba Connected. REVOKE CREATE USER FROM hr; Revoke succeeded. Which two are true about the result and effects of executing these commands? (Choose two.) A. The REVOKE statement successfully revokes the system privilege from Alice. B. User Alice is not permitted to revoke the CREATE USER from user John. C. The REVOKE statement successfully revokes the system privilege from user HR. D. User Alice is permitted to grant the CREATE USER privilege to user HR. E. User HR is permitted to grant the CREATE USER privilege to any other user. F. User Alice is permitted to grant the CREATE USER privilege to user HR only.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!