Machine-translated by Google. Questions are authored in English.
Top

Discussion

Some of the columns of a relation are at different sites is which of the following?

  • A.Data Replication
  • B.Horizontal Partitioning
  • C.Vertical Partitioning
  • D.Horizontal and Vertical Partitioning

Answer: C

Correct answer: Vertical Partitioning

Vertical partitioning divides a relation by column, keeping the primary key with each fragment so the original can be reconstructed by a join. It suits a case where different sites use different attributes of the same entity - personnel data at one site and payroll data at another, for the same employees.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.