Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Data Replication Horizontal and Vertical Partitioning Vertical Partitioning Horizontal Partitioning Data Replication Horizontal and Vertical Partitioning Vertical Partitioning Horizontal Partitioning 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 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. True False True False 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 The problem of concurrency control is more complex in a distributed database. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A transaction manager is which of the following? Maintains appropriate concurrency control All of these Maintains a log of transactions Maintains before and after database images Maintains appropriate concurrency control All of these Maintains a log of transactions Maintains before and after database images ANSWER DOWNLOAD EXAMIANS APP