Which of the following is true about horizontal partitioning?
A) Data can be stored to optimize local access.
B) Data are less secure.
C) There is consistent access speed.
D) None of the above

Question

Quizplus · Accepted Answer

Horizontal partitioning is a database sharding technique that involves splitting a database into multiple smaller sub-databases or partitions, and each partition stores a subset of the data. This allows data to be stored closer to where it is being accessed, optimizing local access. However, it can also result in less secure data if not properly managed. Consistent access speed may not always be guaranteed as it depends on how the data is partitioned and accessed.

Which of the Following Is True About Horizontal Partitioning