Multiple choice technology databases

CREATE DATABASE command creates some default table spaces. What are they? Choose all that apply.

  1. SYSLOGSPACE

  2. TEMPSPACE1

  3. USERSPACE1

  4. SYSCATSPACE

Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

When a DB2 database is created, the system automatically creates default tablespaces: SYSCATSPACE (for the system catalog), TEMPSPACE1 (for system temporary tables), and USERSPACE1 (the default space for user tables). SYSLOGSPACE is not a default tablespace.