Distributed Databases Location transparency allows for which of the following? Managers to treat the data as if it is at one location Users 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 Managers to treat the data as if it is at one location Users 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 ANSWER DOWNLOAD EXAMIANS APP
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 An autonomous homogenous environment is which of the following? A different DBMS is at each node and each DBMS works independently. The same DBMS is at each node and each DBMS works independently. The same DBMS is at each node and a central DBMS coordinates database access. A different DBMS is at each node and a central DBMS coordinates database access. A different DBMS is at each node and each DBMS works independently. The same DBMS is at each node and each DBMS works independently. The same DBMS is at each node and a central DBMS coordinates database access. A different DBMS is at each node and a central DBMS coordinates database access. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Some of the columns of a relation are at different sites is which of the following? Data Replication Horizontal Partitioning Vertical Partitioning Horizontal and Vertical Partitioning Data Replication Horizontal Partitioning Vertical Partitioning Horizontal and Vertical Partitioning 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. False True False True 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS