Multiple choice

Which of the following storage structures provides a way to physically store rows from more than one table in the same data block?

  1. Cluster table

  2. Partitioned table

  3. Unclustered table

  4. Index-organized table
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Cluster tables allow rows from multiple tables to be stored in the same data block based on a cluster key. This improves join performance for frequently joined tables. Partitioned tables split a single table, unclustered is the default, and index-organized tables store data within the index structure.

Keep practicing — related questions