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 (assigned at user creation). The SYSTEM tablespace is for Oracle data dictionary. Users tablespace is not a default concept.

Keep practicing — related questions