Question 1

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.

Accepted Answer

The answer of The ____________________ commit protocol guarantees that if...

Question 2

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

Accepted Answer

The answer of A fully distributed database management system must...

Question 3

Explain the difference between homogeneous and heterogeneous distributed database systems.

Accepted Answer

The answer of Explain the difference between homogeneous and heterogeneous...

Question 4

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

Accepted Answer

The answer of The DO-UNDO-REDO protocol defines three types of...

Question 5

The database description, known as the distributed ____________________ schema, is the common database schema used by local TPs to translate user requests into subqueries (remote requests) that will be processed by different DPs.

Accepted Answer

The answer of The database description, known as the distributed...

Question 6

What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?

Accepted Answer

The answer of What is transaction transparency? What are some...

Question 7

If a DDBMS exhibits ____________________ transparency, the user does not need to know that the data are partitioned-meaning the table's rows and columns are split vertically or horizontally and stored among multiple sites.

Accepted Answer

The answer of If a DDBMS exhibits ____________________ transparency, the...

Question 8

Describe performance transparency and heterogeneity transparency.

Accepted Answer

The answer of Describe performance transparency and heterogeneity transparency....

Question 9

The ____________________ fragment condition indicates that each row is unique, regardless of the fragment in which it is located.

Accepted Answer

The answer of The ____________________ fragment condition indicates that each...

Question 10

Typically, the __________________________________________________ scenario requires a network file server running conventional applications that are accessed through a network.

Accepted Answer

The answer of Typically, the __________________________________________________ scenario requires a network...

Quiz 10: Distributed Databases