DISTRIBUTED DATABASES QUIZ

Replication should be used when which of the following exist?

When using many nodes with different operating systems and DBMSs and database designs.

All of these

When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.

The application's data can be somewhat out-of-date.

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 : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Horizontal and Vertical Partitioning

Data Replication

Horizontal Partitioning

Vertical Partitioning

TRUE ANSWER : ?
YOUR ANSWER : ?

A heterogeneous distributed database is which of the following?

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 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.

TRUE ANSWER : ?
YOUR ANSWER : ?

Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The purpose of timestamping is to avoid the use of locks.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A distributed database has which of the following advantages over a centralized database?

Software complexity

Modular growth

Software cost

Slow Response

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not one of the stages in the evolution of distributed DBMS?

Distributed request

Remote unit of work

Distributed unit of Work

Unit of work

TRUE ANSWER : ?
YOUR ANSWER : ?

↑