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

distributed database systems integrate different types of centralized database management systems (DBMS) over a network.

A) Homogeneous
B) Heterogeneous
C) Fully homogeneous
D) Combination

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

The fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is located.

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

A request lets a single SQL statement reference data located at several different local or remote DP sites.

In a distributed database management system (DDBMS), occurs to determine the data location of local and remote fragments.

transparency allows data to be updated simultaneously at several network sites.

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

transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

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.

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

The scenario is typical of most mainframe and midrange UNIX/LINUX server database management systems (DBMS).

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

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

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

management ensures that data move from one consistent state to another.

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

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

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