DISTRIBUTED DATABASES QUIZ

An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A homogenous distributed database is which of the following?

A different 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 not distributed across all nodes.

The same DBMS is used at each location and data are distributed across all nodes.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is a disadvantage of replication?

If the database fails at one site, a copy can be located at another site.

Reduced network traffic

Each transaction may proceed without coordination across the network.

Each site must have the same storage capacity.

TRUE ANSWER : ?
YOUR ANSWER : ?

Data replication is favored where most process requests are read-only and where the data are relatively static.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Storing a separate copy of the database at multiple locations is which of the following?

Data Replication

Vertical Partitioning

Horizontal Partitioning

Horizontal and Vertical Partitioning

TRUE ANSWER : ?
YOUR ANSWER : ?

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Horizontal Partitioning

Horizontal and Vertical Partitioning

Vertical Partitioning

Data Replication

TRUE ANSWER : ?
YOUR ANSWER : ?

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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 single logical database that is spread to multiple locations and is interconnected by a network

A loose collection of file that is limited to one location.

TRUE ANSWER : ?
YOUR ANSWER : ?