Distributed Databases 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases The problem of concurrency control is more complex in a distributed database. False True False True ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database can use which of the following strategies? Totally centralized at one location and accessed by many sites All of these Partitioned into segments at different sites Partially or totally replicated across sites Totally centralized at one location and accessed by many sites All of these Partitioned into segments at different sites Partially or totally replicated across sites ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Which of the following is true concerning a global transaction? 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 passes the request to only the local DBMS. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS. 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 routes requests as necessary. 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 passes the request to only the local DBMS. The required data are at one local site and the distributed DBMS routes requests as necessary. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Horizontal Partitioning Horizontal and Vertical Partitioning Vertical Partitioning Data Replication Horizontal Partitioning Horizontal and Vertical Partitioning Vertical Partitioning Data Replication ANSWER DOWNLOAD EXAMIANS APP