Multiple choice technology programming languages

Which two statements are true about the role in Oracle Database?

  1. A role can contain both system and object privileges.

  2. A role cannot be assigned external authentication.

  3. A role can be granted to itself.

  4. Roles are owned by the SYS user

  5. Roles can be granted to other roles
Reveal answer Fill a bubble to check yourself
A,E Correct answer
Explanation

Roles in Oracle can contain both system privileges (like CREATE TABLE) and object privileges (like SELECT on a table). Roles can be granted to other roles, enabling privilege hierarchies. Roles cannot be granted to themselves (circular reference). Roles are not owned by SYS specifically - they're schema-independent objects. External authentication can be assigned to roles.

Keep practicing — related questions