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

Each Oracle user has a default tablespace attribute defined in their user profile. When creating objects without specifying TABLESPACE clause, Oracle stores the segment in that user's default tablespace. The SYSTEM tablespace is for dictionary objects, and Oracle won't error - it uses the predefined default.

Keep practicing — related questions