Multiple choice technology

Ensure related records come together. What type of partitioning is this?

  1. Same

  2. Entire

  3. Hash By Key

  4. Range

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Range partitioning groups related records together based on key value ranges, ensuring data with similar keys lands in the same partition. Same maintains existing partitions, Entire broadcasts to all, Hash uses hash algorithm. Range is ideal for maintaining data locality.