Oracle Database Administration I — Question 157

Which three statements are true about roles? (Choose three.)

Answer options

• A. Object privileges may not be granted to roles.
• B. The SET ROLE statement can enable one or more roles for a session.
• C. Roles may be granted to roles.
• D. The SET ROLE statement can disable one or more roles for a session.
• E. All roles granted to a user are set on by default when the user logs in
• F. Roles must be password protected.

Correct answer: B, C, D

Explanation

Option B is correct because the SET ROLE statement is used to enable roles in a session. Option C is valid as roles can indeed be granted to other roles for hierarchical permission management. Option D is also correct since the SET ROLE statement can disable roles during a session, while options A, E, and F are incorrect as they misrepresent the functionality and requirements of roles.