FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Distributed Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Short Answer

Review LaterAdd Note

Review Later

An optimization strategy that permits each part of a transaction to be committed in sequence is called ________ optimization.

Correct Answer

verified

Show Answer

Question 52

Essay

Review LaterAdd Note

Review Later

What are the functions of a distributed DBMS?

Correct Answer

verified

In a distributed database environment,th...

View Answer

Show Answer

Question 53

True/False

Review LaterAdd Note

In a heterogeneous environment,not all users use the same DBMS.

What are the three steps that a distributed DBMS uses to develop a query plan?

The sequence of instructions required to process a transaction is called the:

The overriding principle in distributed database design is that data should be stored at one central site.

Applications that can tolerate out-of-date data are not the best candidates for data replication.

A synchronized replication strategy has a(n) ________ reliability.

A distributed unit of work allows various statements within a unit of work to refer to ________ remote DBMS locations.

Combining data across vertical partitions is generally more difficult than combining across horizontal partitions.

A local transaction is one that requires reference only to data that are stored at the site where the transaction originates.

Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.

Which of the following are business conditions that encourage the use of distributed databases?

What is data replication?

The step in which a distributed database decides the order in which to execute the distributed query is called:

What are some of the advantages and disadvantages of a distributed database?

With an asynchronous distributed database,all data across the network is continuously kept up-to-date.

An environment in which data are distributed across all nodes,and there is a global schema,is called a(n)________ environment.

Two-phase commit is an algorithm for coordinating deletions in a distributed database management system.

With ________,users can act as if all the data were located at a single node.