Multiple choice

The DBA is creating a new user. Which of the following is not defined at user creation?

  1. default tablespace

  2. profile

  3. idle_time

  4. default role

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When creating a user, Oracle allows specifying default tablespace, profile, and default roles. The idle_time parameter is a resource limit that belongs in a PROFILE, not a direct user creation parameter. You must create or modify a profile with idle_time settings, then assign that profile to the user. Resource limits are profile-level settings, not user-level.

Keep practicing — related questions