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

Under the scenario,all record- and file-locking activities are performed at the end-user location.

A) single-site processing,single-site data
B) multiple-site processing,single-site data
C) single-site processing,multiple-site data
D) multiple-site processing,multiple-site data

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

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

One of the advantages of a distributed database management system (DDBMS)is less danger of a single- failure.

A database management system (DBMS)must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

A contains the description of the entire database as seen by the database administrator.

In theory,a(n) can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

Discuss the CAP Theorem and the three desirable properties it mentions.

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

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

A transaction processor is also known as the processor.

One of the advantages of a distributed database management system (DDBMS)is that the data is located near the site with the least demand.

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

The protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

fragmentation allows a user to break a single object into two or more segments,or fragments.

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

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