Oracle Database SQL — Question 257

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

Answer options

• A. Roles are assigned to users using the ALTER USER statement.
• B. Privileges are assigned to a role using the GRANT statement.
• C. A role is a named group of related privileges that can only be assigned to a user.
• D. A single user can be assigned multiple roles.
• E. Privileges are assigned to a role using the ALTER ROLE statement.
• F. Roles are assigned to roles using the ALTER ROLE statement.
• G. A single role can be assigned to multiple users.

Correct answer: B, D, G

Explanation

The correct answers are B, D, and G because privileges can indeed be granted to a role using the GRANT statement, a single user can have multiple roles assigned to them, and a single role can be assigned to several users. Options A and C are incorrect because roles can be assigned to roles and are not limited to user assignments alone, while E and F are not valid since ALTER ROLE is not the command used to assign privileges to roles.