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

In Oracle, if a user creates a segment (like a table) without specifying a tablespace, the database automatically assigns it to the default tablespace defined in that specific user's profile configuration.