%_Replication should be used when which of the following exist?_% – McqOptions

MCQOPTIONS

1.	%_Replication should be used when which of the following exist?_%
A.	When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
B.	When using many nodes with different operating systems and DBMSs and database designs.
C.	The application's data can be somewhat out-of-date.
D.	All of the above.
Answer» D. All of the above.

Discussion

No Comment Found

Related MCQs

The purpose of timestamping is to avoid the use of locks.~!
The problem of concurrency control is more complex in a distributed database.~!
With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted.~!
A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.%!
In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.%!
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.%!
Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.%!
The semijoin approach saves network traffic.%!
Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.%!
An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.%!