The ____ approach to setting up a distributed DBMS combines fragmentation and replication.
A)optimization
B)allocation
C)encapsulation
D)normalization

Question

Quizplus · Accepted Answer

The allocation approach involves dividing the database into fragments and replicating some of these fragments to improve availability and performance. This approach combines the benefits of both fragmentation and replication. The optimization approach tries to find the most efficient way to distribute the database, while the encapsulation approach involves hiding the distributed nature of the database from the users. Normalization is a design technique for reducing data redundancy and improving data integrity.

The ____ Approach to Setting Up a Distributed DBMS Combines