Intermediate
Database Management Systems
Q49 / 100
What is database partitioning?
Correct! Well done.
Incorrect.
The correct answer is B) Dividing a large table into smaller segments (partitions) stored separately, improving query performance via partition pruning
B
Correct Answer
Dividing a large table into smaller segments (partitions) stored separately, improving query performance via partition pruning
Explanation
Partitioning (range, hash, list, composite) splits table data physically. Queries on the partition key skip non-relevant partitions (partition pruning), dramatically reducing I/O for large tables.
Progress
49/100