Exam 12: Distributed Databases

________ is a design goal in distributed database systems,which says that even though a data item may be replicated at several nodes throughout the network,a user may treat the data item as if it were a single data item at a single node.

(Short Answer)

4.9/5

(41)

Question 61

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

(Multiple Choice)

4.9/5

(37)

Question 62

Which of the following is true about horizontal partitioning?

(Multiple Choice)

4.8/5

(37)

Question 63

Discuss the different types of data replication.

(Essay)

4.9/5

(33)

Question 64

A distributed request allows a single SQL statement to refer to tables in more than one remote DBMS.

(True/False)

4.9/5

(29)

Question 65

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

(True/False)

4.8/5

(39)

Question 66

Failure transparency is a design goal for distributed databases that guarantees that all the actions associated with a transaction are either committed or none of them are committed.

(True/False)

4.7/5

(32)

Question 67

A ________ allows a single SQL statement to refer to tables in more than one remote DBMS.

(Multiple Choice)

4.9/5

(33)

Question 68

What is horizontal and vertical partitioning?

(Essay)

4.7/5

(41)

Question 69

A distributed database is not just a collection of files.

(True/False)

4.9/5

(36)

Question 70

A centralized strategy has ________ expandability.

(Multiple Choice)

5.0/5

(37)

Question 71

________ is implemented by placing some rows of a table at one site and other rows at another site.

(Short Answer)

4.9/5

(37)

Question 72

Distributed databases do not easily satisfy both transaction and analytical processing systems.

(True/False)

4.8/5

(28)

Question 73

A(n)________ enables a single SQL statement to refer to tables in more than one remote DBMS.

(Short Answer)

4.8/5

(31)

Question 74

A remote unit of work allows updates at the single remote computer.

(True/False)

4.8/5

(28)

Question 75

Replicated databases usually result in tightly coupled nodes.

(True/False)

4.7/5

(32)

Question 76

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

(Short Answer)

4.7/5

(40)

Question 77

A design goal for distributed databases that states that although a distributed database runs many transactions,it appears that a given transaction is the only one in the system is called:

(Multiple Choice)

4.7/5

(41)

Question 78

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

(True/False)

4.7/5

(26)

Question 79

One way to generate store and forward messages for completed transactions to be broadcast across a network is through the use of:

(Multiple Choice)

4.7/5

(26)

Question 80

Showing 61 - 80 of 109

________ is a design goal in distributed database systems,which says that even though a data item may be replicated at several nodes throughout the network,a user may treat the data item as if it were a single data item at a single node.

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

Which of the following is true about horizontal partitioning?

Discuss the different types of data replication.

A distributed request allows a single SQL statement to refer to tables in more than one remote DBMS.

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

Failure transparency is a design goal for distributed databases that guarantees that all the actions associated with a transaction are either committed or none of them are committed.

A ________ allows a single SQL statement to refer to tables in more than one remote DBMS.

What is horizontal and vertical partitioning?

A distributed database is not just a collection of files.

A centralized strategy has ________ expandability.

________ is implemented by placing some rows of a table at one site and other rows at another site.

Distributed databases do not easily satisfy both transaction and analytical processing systems.

A(n)________ enables a single SQL statement to refer to tables in more than one remote DBMS.

A remote unit of work allows updates at the single remote computer.

Replicated databases usually result in tightly coupled nodes.

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

A design goal for distributed databases that states that although a distributed database runs many transactions,it appears that a given transaction is the only one in the system is called:

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

One way to generate store and forward messages for completed transactions to be broadcast across a network is through the use of:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters