Multiple choice

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

  5. Undefined

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

When a user creates an object without specifying a tablespace, Oracle stores it in that user's default tablespace. This is set at user creation time with the DEFAULT TABLESPACE clause or inherited from the database default.