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 31

True/False

Review LaterAdd Note

Review Later

A remote transaction,composed of several requests,may access data at multiple sites.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Essay

Review LaterAdd Note

Review Later

A fully distributed database management system must perform all of the functions of a centralized DBMS.What are these functions?

Correct Answer

verified

1.Receive the request of an application ...

View Answer

Show Answer

Question 33

True/False

Review LaterAdd Note

Distributed processing does not require a distributed database,and a distributed database does not require distributed processing.

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

A transaction processor is the software component residing on each computer that stores and retrieves data located at the site.

The DO-UNDO-REDO protocol defines three types of operations.What are they?

The ____ processor is the software component found in each computer that requests data.It receives and processes the application's data requests.

The TP is the software component found in each computer that requests data.

____ transparency allows the integration of several different local DBMSs under a common,or global,schema.

____ transparency allows a transaction to update data at several network sites.

____________________ management ensures that data move from one consistent state to another,including synchronization of local and remote transactions.

Current DDBMSs are subject to some problems,such as the complexity of management and control.

____ transparency allows the system to perform as if it were a centralized database management system.

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

A(n) ____ database stores each database fragment at a single site.

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

____ transparency allows a distributed database to be treated as a single logical database.

The inherently complex distributed data environment increases the urgency for standard protocols governing transaction management.

The ____________________ commit protocol guarantees that if a portion of a transaction operation cannot be committed,all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.