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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) database
B) transaction
C) data
D) network

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

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.

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

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

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

A transaction processor is also known as the _____ processor.

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

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

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

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?

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

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

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:

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

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

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