Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.
A. True
B. False
Answer: Option A
Solution (By Examveda Team)
In pull replication, synchronization is less disruptive compared to other replication methods because updates occur only when needed by each site, rather than being dictated by a central master site.Option A: True
This option correctly describes the characteristic of pull replication. In pull replication, individual sites or nodes initiate the synchronization process based on their own needs or schedules. When a site requires updates from other nodes, it pulls the necessary data or changes from those nodes. This approach allows each site to control the timing and frequency of synchronization, reducing the potential for disruption to ongoing operations. Pull replication is particularly suitable for distributed environments where network bandwidth or resource constraints may limit the feasibility of continuous or frequent updates from a central master site.
Option B: False
This option contradicts the statement provided in the question. It suggests that synchronization in pull replication is more disruptive or occurs according to a schedule determined by a central master site, which is not accurate. Pull replication is specifically designed to offer flexibility and minimize disruption by allowing individual sites to trigger synchronization as needed, based on local requirements and conditions.
Therefore, in the context of synchronization in pull replication in distributed database systems, the correct option is True (Option A).
A distributed database has which of the following advantages over a centralized database?
A. Software cost
B. Software complexity
C. Slow Response
D. Modular growth
An autonomous homogenous environment is which of the following?
A. The same DBMS is at each node and each DBMS works independently.
B. The same DBMS is at each node and a central DBMS coordinates database access.
C. A different DBMS is at each node and each DBMS works independently.
D. A different DBMS is at each node and a central DBMS coordinates database access.
A transaction manager is which of the following?
A. Maintains a log of transactions
B. Maintains before and after database images
C. Maintains appropriate concurrency control
D. All of the above
Location transparency allows for which of the following?
A. Users to treat the data as if it is at one location
B. Programmers to treat the data as if it is at one location
C. Managers to treat the data as if it is at one location
D. All of the above

Join The Discussion