Distributed Databases Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Some of the columns of a relation are at different sites is which of the following? Horizontal Partitioning Vertical Partitioning Horizontal and Vertical Partitioning Data Replication Horizontal Partitioning Vertical Partitioning Horizontal and Vertical Partitioning Data Replication ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database has which of the following advantages over a centralized database? Modular growth Software cost Software complexity Slow Response Modular growth Software cost Software complexity Slow Response ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Location transparency allows for which of the following? Managers to treat the data as if it is at one location Programmers to treat the data as if it is at one location All of these Users to treat the data as if it is at one location Managers to treat the data as if it is at one location Programmers to treat the data as if it is at one location All of these Users to treat the data as if it is at one location 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Which of the following is a disadvantage of replication? 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. Each transaction may proceed without coordination across the network. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS