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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) sections
B) fragments
C) partitions
D) parts

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

A DDBMS is subject to which of the following restrictions?

A) Multiple instances of the same database should be integrated over a network.
B) All database processing must be done at a single site.
C) Rapid ad hoc data access is not possible.
D) Remote data access is provided on a read-only basis.

E) A) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

The level of transparency supported by the distributed database management system remains the same for all systems.

Explain the difference between homogeneous and heterogeneous distributed database management systems (DDBMS).

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

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

Distributed data access was needed to support geographically dispersed business units.

One of the advantages of a distributed database management system (DDBMS)is processor .

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

The Internet is the repository for distributed data.

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

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

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

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 fragment condition indicates that no row has a duplicate,regardless of the fragment in which it is located.

Describe performance transparency and heterogeneity transparency.

The distributed database system must be of the computer hardware system.

A disadvantage of a distributed database management system (DDBMS) is that:

Describe any five of the 12 commandments formulated by C.J.Date for distributed databases.

In a distributed database management system (DDBMS),query is used to find the best access strategy.