Multiple choice technology databases

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Default tablespace for system
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a user creates an object in Oracle without specifying a TABLESPACE clause, Oracle stores the segment in that user's default tablespace. This is a user-specific default, not the system tablespace. Each user can be assigned a specific default tablespace for their objects.

Keep practicing — related questions