Oracle Database Administration I — Question 171

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which four actions can HR perform? (Choose four.)

Answer options

• A. Revoke the CREATE SESSION privilege from other users
• B. Revoke the CREATE SESSION privilege from user HR
• C. Log in to the database instance
• D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E. Execute DDL statements in the HR schema
• F. Execute DML statements in the HR schema

Correct answer: A, B, C, D

Explanation

The correct answer includes A, B, C, and D because granting the CREATE SESSION privilege with ADMIN OPTION allows HR to manage this privilege for themselves and others, including revoking it. Options E and F are incorrect because the command does not grant DDL or DML privileges, only the ability to create sessions.