Multiple choice technology databases

What is the maximum number of tables that can be stored on a Partitioned Table Space?

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In DB2, a partitioned table space can contain only one table. The partitioning is used to distribute that single table's data across multiple data partitions based on key ranges. Segmented table spaces can hold multiple tables, but partitioned table spaces are designed for single-table optimization.

Keep practicing — related questions