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. This is different from segmented table spaces which can contain multiple tables. The partitioning is designed to distribute a single large table across multiple storage partitions for performance and manageability. Each partition holds a portion of the same table based on partitioning keys.

Keep practicing — related questions