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 stores the segment in the user's default tablespace. This is assigned when the user is created and can be viewed with the DEFAULT_TABLESPACE column in DBA_USERS. The SYSTEM tablespace is reserved for data dictionary objects.

Keep practicing — related questions