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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) growing numbers of remote locations
B) maintaining and operating small database systems
C) dependence on multiple sites
D) organizational flexibility of the database

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

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) All of the above
F) None of the above

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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.

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

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

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

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

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.

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

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

Theweb is the repository for distributed data.

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

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

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.

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

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

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