Partitioning
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is Partitioning in a database?
2. What does each data partition consist of?
3. If a Salary table holding 10 years of data is partitioned yearly, how is it divided at the storage level?
4. When partitions are stored wherever empty slots exist, so that several partitions may land on one node of a cluster, what is this arrangement called?
5. In the yearly Salary example, a query for years 2 and 3 hits only two partitions, but both sit on the same node. What is the consequence?
6. What is Horizontal Partitioning?
7. What is Vertical Partitioning?
8. Which of the following is NOT a single-level partitioning technique?
9. Which of the following is a composite partitioning technique?
10. Which of the following is NOT a stated benefit of partitioning?