Distributed Databases Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases. 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. Each transaction may proceed without coordination across the network. Each site must have the same storage capacity. Reduced network traffic If the database fails at one site, a copy can be located at another site. Each transaction may proceed without coordination across the network. Each site must have the same storage capacity. Reduced network traffic ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A homogenous distributed database is which of the following? The same DBMS is used at each location and data are distributed across all nodes. The same DBMS is used at each location and data are not distributed across all nodes. A different DBMS is used at each location and data are distributed across all nodes. A different DBMS is used at each location and data are not distributed across all nodes. The same DBMS is used at each location and data are distributed across all nodes. The same DBMS is used at each location and data are not distributed across all nodes. A different DBMS is used at each location and data are distributed across all nodes. A different DBMS is used at each location and data are not distributed across all nodes. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Location transparency allows for which of the following? All of these Users to treat the data as if it is at one location Programmers to treat the data as if it is at one location Managers 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 Programmers to treat the data as if it is at one location Managers to treat the data as if it is at one location ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Vertical Partitioning Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication Vertical Partitioning Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases The purpose of timestamping is to avoid the use of locks. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS