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. Oracle will give an error
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a TABLESPACE clause is omitted, Oracle stores the segment in the user's default tablespace. Each database user has a default tablespace assigned (often USERS or a custom tablespace). The SYSTEM tablespace is reserved for data dictionary objects. Oracle will not give an error - it uses the default tablespace as a fallback.

Keep practicing — related questions