Some of the columns of a relation are at different sites is which of the following? Horizontal and Vertical Partitioning Horizontal Partitioning Vertical Partitioning Data Replication TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not one of the stages in the evolution of distributed DBMS? Distributed request Remote unit of work Unit of work Distributed unit of Work TRUE ANSWER : ? YOUR ANSWER : ?
Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment. False True TRUE ANSWER : ? YOUR ANSWER : ?
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. True False TRUE ANSWER : ? YOUR ANSWER : ?
A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is true concerning a global transaction? The required data are at one local site and the distributed DBMS passes the request to only the local DBMS. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary. The required data are at one local site and the distributed DBMS routes requests as necessary. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS. TRUE ANSWER : ? YOUR ANSWER : ?
A distributed database is which of the following? A single logical database that is spread to multiple locations and is interconnected by a network A single logical database that is limited to one location. A loose collection of file that is limited to one location. A loose collection of file that is spread to multiple locations and is interconnected by a network TRUE ANSWER : ? YOUR ANSWER : ?
The problem of concurrency control is more complex in a distributed database. True False TRUE ANSWER : ? YOUR ANSWER : ?
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. False True TRUE ANSWER : ? YOUR ANSWER : ?
Data replication is favored where most process requests are read-only and where the data are relatively static. False True TRUE ANSWER : ? YOUR ANSWER : ?