In a semijoin, only the joining attribute is sent from one site to ano – McqOptions

MCQOPTIONS

1.	In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.%!
A.	True
B.	False
Answer» B. False

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.%!