Distributed Databases With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Location transparency allows for which of the following? 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 Managers to treat the data as if it is at one location Users to treat the data as if it is at one location ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases The problem of concurrency control is more complex in a distributed database. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Horizontal and Vertical Partitioning Vertical Partitioning Horizontal Partitioning Data Replication Horizontal and Vertical Partitioning Vertical Partitioning Horizontal Partitioning Data Replication 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. A different DBMS is at each node and a central DBMS coordinates database access. The same DBMS is at each node and a central DBMS coordinates database access. The same DBMS is at each node and each DBMS works independently. A different DBMS is at each node and each DBMS works independently. A different DBMS is at each node and a central DBMS coordinates database access. The same DBMS is at each node and a central DBMS coordinates database access. The same DBMS is at each node and each DBMS works independently. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A semijoin is which of the following? All of the attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then only the required rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then all of the rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then only the required rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then all of the rows are returned. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS