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

  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 the user's default tablespace. This is assigned to the user when created or altered with the DEFAULT TABLESPACE clause. The SYSTEM tablespace is for dictionary objects, not user data.

Keep practicing — related questions