Distributed Databases
Some of the columns of a relation are at different sites is which of the following?

Horizontal and Vertical Partitioning
Horizontal Partitioning
Data Replication
Vertical Partitioning

ANSWER DOWNLOAD EXAMIANS APP

Distributed Databases
Which of the following is a disadvantage of replication?

Each site must have the same storage capacity.
If the database fails at one site, a copy can be located at another site.
Each transaction may proceed without coordination across the network.
Reduced network traffic

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 a central DBMS coordinates database access.
A different 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