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. Undefined

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

If a user creates a database object (like a table) without specifying a TABLESPACE clause, Oracle automatically stores the segment in the default tablespace assigned to that user.