Oracle
1Z0-072 · Question #47
In the ORCL database, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO HR WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)
The correct answer is B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users. D. Log in to the database instance. E. Revoke the CREATE SESSION privilege from other users. See the full explanation below for the reasoning.
Question
In the ORCL database, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO HR WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)
Options
- AGrant the CREATE SESSION privilege without ADMIN OPTION to other users.
- BGrant the CREATE SESSION privilege with ADMIN OPTION to other users.
- CExecute DML statements in the HR schema.
- DLog in to the database instance.
- ERevoke the CREATE SESSION privilege from other users.
- FExecute DDL statements in the HR schema.
How the community answered
(42 responses)- A14% (6)
- B76% (32)
- C5% (2)
- F5% (2)
Community Discussion
No community discussion yet for this question.