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
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When no TABLESPACE clause is specified, Oracle automatically stores the segment in the user's default tablespace. This is the tablespace assigned to the user when their account was created or last modified with an ALTER USER statement. The system tablespace is reserved for data dictionary objects, not user data.

Keep practicing — related questions