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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Essay

Review LaterAdd Note

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.