Multiple choice

What is a default role?

  1. A role that requires a password

  2. A role that requires no password

  3. A role automatically enabled when the user logs on

  4. A role automatically assigned when the user is created
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A default role in Oracle is automatically enabled for a user when they log on to the database. It does not require a password (that would be a password-protected role). Default roles are set via the ALTER USER DEFAULT ROLE command, not automatically assigned when user is created.

Keep practicing — related questions