Multiple choice technology databases

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  1. System tablespace

  2. Default tablespace for the user

  3. Users tablespace

  4. Oracle will give an error

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

When a user creates an object without specifying a tablespace, Oracle stores it in that user's default tablespace. This is defined in the user profile. It does not use the system tablespace or throw an error.