Multiple choice technology databases

What tablespace is automatically created when we create a database

  1. The Default tablespace

  2. The temp tablespace

  3. The SYSTEM tablespace

  4. None of the above

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

When an Oracle database is created, the SYSTEM tablespace is automatically created first. This tablespace contains the data dictionary and essential database metadata. The SYSTEM tablespace is always present and required for database operation, while other tablespaces like temporary tablespaces are created separately or as needed.