Question 1

Explain the difference between a synchronous and asynchronous distributed database.

Accepted Answer

A synchronous distributed database keeps

Question 2

Replication transparency 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.

Accepted Answer

A) True 
 B)False

Question 3

A distributed database is NOT just a collection of files.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

1. Query decomposition-simplify and rewr

Question 5

With ________, all of the actions of a transaction are either committed or not committed.

Accepted Answer

A)  location transparency 
B)  replication transparency 
C)  failure transparency 
D)  commit transparency 
A)  location transparency 
B)  replication transparency 
C)  failure transparency 
D)  commit transparency

Question 6

All of the following are disadvantages of data replication EXCEPT:

Accepted Answer

A)  storage requirements. 
B)  reduced network traffic at prime time. 
C)  cost of updating. 
D)  complexity. 
A)  storage requirements. 
B)  reduced network traffic at prime time. 
C)  cost of updating. 
D)  complexity.

Question 7

A transaction that requires only reference to data that are stored at the site is a remote transaction.

Accepted Answer

A) True 
 B)False

Question 8

Location translucency enables users and programmers to treat data as if it were located at one node even though it may move from node to node.

Accepted Answer

A) True 
 B)False

Question 9

An optimization strategy that allows sites that can update to proceed and other sites to catch up is called:

Accepted Answer

A)  read-only commit. 
B)  lazy commit. 
C)  sequenced commit. 
D)  linear set up. 
A)  read-only commit. 
B)  lazy commit. 
C)  sequenced commit. 
D)  linear set up.

Question 10

What are the three different kinds of transparencies used in distributed database management systems?

Accepted Answer

Transparency isolates a user from the co

Question 11

Horizontal partitioning offers increased efficiency because data are close to use areas.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following supports a simple path to other databases, without the benefits of one logical database?

Accepted Answer

A)  Linked; differential 
B)  Gateways 
C)  Autonomous; cross-linked 
D)  Federated; nonautonomous 
A)  Linked; differential 
B)  Gateways 
C)  Autonomous; cross-linked 
D)  Federated; nonautonomous

Question 13

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

Accepted Answer

Either form of distributed databases has

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

What is the difference between a local transaction and a global transaction?

Accepted Answer

A local transaction is one in a distribu

Question 17

A centralized strategy has ________ expandability.

Accepted Answer

A)  excellent 
B)  good 
C)  poor 
D)  medium 
A)  excellent 
B)  good 
C)  poor 
D)  medium

Question 18

Describe the range of distributed database environments.

Accepted Answer

The range of distributed databases falls

Question 19

Organizational forces such as funding availability drive the choice of distributed database strategy.

Accepted Answer

A) True 
 B)False

Question 20

Replication transparency allows a programmer or user to treat a replicated data item as if it were a single item at a single node.

Accepted Answer

A) True 
 B)False

Explain the difference between a synchronous and asynchronous distributed database.

Replication transparency 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 distributed database is NOT just a collection of files.

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

With ________, all of the actions of a transaction are either committed or not committed.

All of the following are disadvantages of data replication EXCEPT:

A transaction that requires only reference to data that are stored at the site is a remote transaction.

Location translucency enables users and programmers to treat data as if it were located at one node even though it may move from node to node.

An optimization strategy that allows sites that can update to proceed and other sites to catch up is called:

What are the three different kinds of transparencies used in distributed database management systems?

Horizontal partitioning offers increased efficiency because data are close to use areas.

Which of the following supports a simple path to other databases, without the benefits of one logical database?

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

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

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

What is the difference between a local transaction and a global transaction?

A centralized strategy has ________ expandability.

Describe the range of distributed database environments.

Organizational forces such as funding availability drive the choice of distributed database strategy.

Replication transparency allows a programmer or user to treat a replicated data item as if it were a single item at a single node.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Object-Oriented Data Modeling

Filters

Exam 13: Distributed Databases

Explain the difference between a synchronous and asynchronous distributed database.

Replication transparency 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 distributed database is NOT just a collection of files.

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

With ________, all of the actions of a transaction are either committed or not committed.

All of the following are disadvantages of data replication EXCEPT:

A transaction that requires only reference to data that are stored at the site is a remote transaction.

Location translucency enables users and programmers to treat data as if it were located at one node even though it may move from node to node.

An optimization strategy that allows sites that can update to proceed and other sites to catch up is called:

What are the three different kinds of transparencies used in distributed database management systems?

Horizontal partitioning offers increased efficiency because data are close to use areas.

Which of the following supports a simple path to other databases, without the benefits of one logical database?

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

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

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

What is the difference between a local transaction and a global transaction?

A centralized strategy has ________ expandability.

Describe the range of distributed database environments.

Organizational forces such as funding availability drive the choice of distributed database strategy.

Replication transparency allows a programmer or user to treat a replicated data item as if it were a single item at a single node.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Object-Oriented Data Modeling

Filters