Multiple choice technology databases

One table can have more than one tablespace

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In DB2, a single table can span multiple tablespaces. This is especially true for partitioned tables where different partitions can be stored in different tablespaces. Even non-partitioned tables can have their data and indexes in different tablespaces. The statement is true.

Keep practicing — related questions