FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Distributed Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

An environment in which data are distributed across all nodes, and there is a global schema, is called a heterogenous environment.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

Distributed databases make data sharing more difficult because of the data communication problems.

Concurrency transparency allows each transaction to appear as if it were the only activity in a distributed database management system.

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

A(n) ________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.

A distributed DBMS must provide consistency among copies of data across the remote sites.

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

What are the five unique ways that a data distribution strategy can be organized?

Location transparency is used to inform users of where data are located within the distributed database.

An integrated partition strategy is ________ to manage.

In a distributed database, a transaction that requires reference to data at one or more nonlocal sites is called a ________ transaction.

Location efficiency enables a user to access data without knowing exactly where the data are located.

Data replication allowing for each transition to proceed without coordination is called:

________ is a design goal for a distributed database, which says a user does not need to know the location of data to use the data.

Which of the following environments uses the same DBMS at each node with a central or master DBMS coordinating database access across nodes?

Which of the following is true about horizontal partitioning?

Data localization involves transforming a query into fragments that explicitly reference data at one site.

Discuss the different types of data replication.

Replication should NOT be used if timely updates are important.