FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Distributed Database Management Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

One of the advantages of a distributed database management system (DDBMS) is _____ operating cost.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

_____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.

A) Data distribution
B) Replica transparency
C) Network latency
D) Network partitioning

E) All of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

A centralized database management is subject to a problem such as _____.

Explain the three types of operations defined by the DO-UNDO-REDO protocol.

A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a(n) _____.

The _____ protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

A distributed database is composed of several parts known as database _____.

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

Theweb is the repository for distributed data.

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.

A distributed database management system (DDBMS) must be communications-media-dependent.

A distributed _____ can reference several different local or remote data processing sites.

The _____ forces the log entry to be written to permanent storage before the actual operation takes place.

A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

The transaction processor (TP) is the software component found in each computer that requests data.

_____ transparency allows the system to operate as if it were a centralized database management system.

The objective of _____ optimization is to minimize the total cost associated with the execution of a request.