Distributed Databases Some of the columns of a relation are at different sites is which of the following? Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication Vertical Partitioning Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication Vertical Partitioning ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases 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 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 transaction manager is which of the following? Maintains appropriate concurrency control Maintains before and after database images All of these Maintains a log of transactions Maintains appropriate concurrency control Maintains before and after database images All of these Maintains a log of transactions ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Horizontal and Vertical Partitioning Data Replication Horizontal Partitioning Vertical Partitioning Horizontal and Vertical Partitioning Data Replication Horizontal Partitioning Vertical Partitioning ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS