Distributed Databases A semijoin is which of the following? 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. All of the attributes are sent from one site to another and then only the required rows are returned. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations. 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 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. 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. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database is which of the following? A single logical database that is limited to one location. A loose collection of file that is spread to multiple locations and is interconnected by a network A loose collection of file that is limited to one location. A single logical database that is spread to multiple locations and is interconnected by a network A single logical database that is limited to one location. A loose collection of file that is spread to multiple locations and is interconnected by a network A loose collection of file that is limited to one location. A single logical database that is spread to multiple locations and is interconnected by a network ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database can use which of the following strategies? Totally centralized at one location and accessed by many sites Partially or totally replicated across sites All of these Partitioned into segments at different sites Totally centralized at one location and accessed by many sites Partially or totally replicated across sites All of these Partitioned into segments at different sites ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Data replication is favored where most process requests are read-only and where the data are relatively static. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS