What is vertical fragmentation in a distributed database?

Options

  • A. Dividing a table into rows
  • B. Dividing a table into columns or attributes
  • C. Deleting duplicate records
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Dividing a table into columns or attributes

Detailed Explanation

Explanation: Vertical fragmentation divides a relation into groups of columns. The primary key is generally included in fragments to allow reconstruction.