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
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? Vertical Partitioning Data Replication Horizontal Partitioning Horizontal and Vertical Partitioning Vertical Partitioning Data Replication Horizontal Partitioning Horizontal and Vertical Partitioning ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned. True False True False 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 Users 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 Programmers to treat the data as if it is at one location Users 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 The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS