_____ fragmentation refers to the division of a relation into subsets of tuples.
A) Vertical
B) Horizontal
C) Data
D) Mixed

Question

Quizplus · Accepted Answer

Horizontal fragmentation refers to the division of a relation into subsets of tuples based on some criteria such as a range of values, a specific attribute, or a condition. This can be useful for distributing data across multiple nodes in a distributed database system. Vertical fragmentation, on the other hand, involves dividing a relation into subsets of attributes, and is often used for reducing redundancy and improving query performance. Data fragmentation refers to the splitting of data across multiple locations or types of storage media. Mixed fragmentation combines elements of both horizontal and vertical fragmentation.

_____ Fragmentation Refers to the Division of a Relation into Subsets