Distributed Databases
A distributed database can use which of the following strategies?

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

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.
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.
Only the joining attributes are sent from one site to another and then only the required rows are returned.

ANSWER DOWNLOAD EXAMIANS APP

Distributed Databases
A heterogeneous distributed database is which of the following?

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.
A different DBMS is used at each location and data are distributed across all nodes.
The same DBMS is used at each location and data are distributed across all nodes.

ANSWER DOWNLOAD EXAMIANS APP