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 you create an object without specifying a TABLESPACE clause, Oracle automatically stores it in that user's default tablespace. This default tablespace is assigned when the user account is created. The system tablespace is reserved for data dictionary objects, not user data.

Keep practicing — related questions