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 1

Short Answer

Review LaterAdd Note

Review Later

In a distributed database management system (DDBMS), _____ control is used to manage simultaneous data access and ensure data consistency across database fragments.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

_____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.

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

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

_____ fragmentation refers to the division of a relation into subsets of tuples.

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

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

A transaction processor is also known as the _____ processor.

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

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

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

In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage 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.

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

A user-friendly _____ is one advantage of a distributed database management system (DDBMS) .

Which propertyof the CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database?

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

The _____ rule requires that all copies of data fragments be identical.

Distributed processing does not require: