Oracle Database 12c: Installation and Administration — Question 68

Which two statements are true? (Choose two.)

Answer options

• A. A role cannot be assigned external authentication.
• B. A role can be granted to other roles.
• C. A role can contain both system and object privileges.
• D. The predefined resource role includes the unlimited_tablespace privilege.
• E. All roles are owned by the sys user.
• F. The predefined connect role is always automatically granted to all new users at the time of their creation.

Correct answer: B, C

Explanation

Option B is correct because roles can indeed be granted to other roles, enabling hierarchical role management. Option C is also true as roles can include both system privileges, which govern database operations, and object privileges, which pertain to specific database objects. The other options are incorrect as they either misrepresent the capabilities of roles or the default behavior associated with user creation.