The _____ approach,used to set up a distributed database management system (DDBMS),combines fragmentation and replication.
A)optimization
B)allocation
C)encapsulation
D)normalization

Question

Quizplus · Accepted Answer

The allocation approach is used to set up a distributed database management system (DDBMS). It combines fragmentation and replication to allocate the data at various sites of the network according to their specific needs. This approach involves dividing the database into fragments and distributing these fragments across different sites based on their accessibility and usage patterns. Replication is used to duplicate data at various sites for faster access and improved reliability. This approach ensures that data remain available in case of network failure, data loss, or data access latency. The optimization approach is used to optimize the performance of DDBMS by selecting the best strategies for data storage and retrieval. Encapsulation approach is used for controlling and managing the access to data across the network. Normalization approach is used to eliminate redundant information in a database.

The _____ Approach,used to Set Up a Distributed Database Management