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

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) request
B) site
C) data location
D) transaction

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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