Multiple choice technology databases

Which of the following are valid table-partitioning methods

  1. Key based

  2. Freelist

  3. Hash

  4. Index
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Hash partitioning is a standard table partitioning method where data is distributed across partitions using a hash function on partition key values. Key-based is not a standard partitioning method name. Freelist relates to space management within segments, not partitioning. Index is a separate access structure, not a partitioning method. Common partitioning methods include range, list, hash, and composite.

Keep practicing — related questions