Distributed Databases With failure transparency, all of the actions of a transaction are committed or none of them are committed. False True False True ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases The semijoin approach saves network traffic. False True False True ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A transaction manager is which of the following? Maintains a log of transactions 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 ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Some of the columns of a relation are at different sites is which of the following? Data Replication Vertical Partitioning Horizontal Partitioning Horizontal and Vertical Partitioning Data Replication Vertical Partitioning Horizontal Partitioning Horizontal and Vertical Partitioning ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Which of the following is a disadvantage of replication? Each transaction may proceed without coordination across the network. If the database fails at one site, a copy can be located at another site. Reduced network traffic Each site must have the same storage capacity. Each transaction may proceed without coordination across the network. If the database fails at one site, a copy can be located at another site. Reduced network traffic Each site must have the same storage capacity. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database can use which of the following strategies? All of these Totally centralized at one location and accessed by many sites Partitioned into segments at different sites Partially or totally replicated across sites All of these Totally centralized at one location and accessed by many sites Partitioned into segments at different sites Partially or totally replicated across sites ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS