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 41

True/False

Review LaterAdd Note

Review Later

Distribution transparency is supported by a distributed data dictionary.

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

The forces the log entry to be written to permanent storage before the actual operation takes place.

Correct Answer

verified

write-ahea...

View Answer

Show Answer

Question 43

True/False

Review LaterAdd Note

The transaction processor (TP) is the software component found in each computer that requests data.

Typically, the scenario requires a network file server running conventional applications that are accessed through a network.

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

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

The processor is the software component residing on each computer that stores and retrieves data located at the site.

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

A transaction processor is also known as the processor.

A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

A DDBMS is subject to which of the following restrictions?

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

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

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

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

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

The World Wide Web is the repository for distributed data.

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

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

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