Distributed Databases The problem of concurrency control is more complex in a distributed database. False True False True ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Location transparency allows for which of the following? All of these Programmers to treat the data as if it is at one location Managers to treat the data as if it is at one location Users to treat the data as if it is at one location All of these Programmers to treat the data as if it is at one location Managers to treat the data as if it is at one location Users to treat the data as if it is at one location ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database has which of the following advantages over a centralized database? Software complexity Slow Response Software cost Modular growth Software complexity Slow Response Software cost Modular growth ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Which of the following is a disadvantage of replication? 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. Each transaction may proceed without coordination across the network. If the database fails at one site, a copy can be located at another site. 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 A distributed database can use which of the following strategies? Partially or totally replicated across sites Partitioned into segments at different sites Totally centralized at one location and accessed by many sites All of these Partially or totally replicated across sites Partitioned into segments at different sites Totally centralized at one location and accessed by many sites All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS