Distributed Databases A homogenous distributed database is which of the following? 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 not distributed across all nodes. The same DBMS is used at each location and data are 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 not distributed across all nodes. The same DBMS is used at each location and data are distributed across all nodes. 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 Some of the columns of a relation are at different sites is which of the following? Vertical Partitioning Horizontal Partitioning Data Replication Horizontal and Vertical Partitioning Vertical Partitioning Horizontal Partitioning Data Replication Horizontal and Vertical Partitioning 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 The semijoin approach saves network traffic. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database has which of the following advantages over a centralized database? Software cost Slow Response Software complexity Modular growth Software cost Slow Response Software complexity Modular growth ANSWER DOWNLOAD EXAMIANS APP