Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?
A) The optimization approach
B) The allocation approach
C) The encapsulation approach
D) The normalization approach

Question

Quizplus · Accepted Answer

The allocation approach is the only one of the listed approaches that combines both the fragmentation and the replication approaches in setting up a distributed database management system (DDBMS). Fragmentation involves dividing a database into smaller pieces (fragments) and distributing them across multiple sites, while replication involves making copies of data and distributing them across multiple sites. The allocation approach combines these two techniques by fragmenting some parts of the database and replicating others in different locations based on specific criteria.

Which of the Following Approaches to Set Up a Distributed