Question 1

An integrated partition strategy is ________ to manage.

Accepted Answer

A)  excellent 
B)  difficult 
C)  easy 
D)  medium 
A)  excellent 
B)  difficult 
C)  easy 
D)  medium

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Replication should NOT be used if timely updates are important.

Accepted Answer

A) True 
 B)False

Question 4

Discuss the different types of data replication.

Accepted Answer

There are several different types of rep

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  distributed database 
B)  decentralized database 
C)  unlinked database 
D)  data repository 
A)  distributed database 
B)  decentralized database 
C)  unlinked database 
D)  data repository

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  reliability. 
B)  fast response. 
C)  node decoupling. 
D)  node coupling. 
A)  reliability. 
B)  fast response. 
C)  node decoupling. 
D)  node coupling.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

________ 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.

Accepted Answer

A)  Location transparency 
B)  Location autonomy 
C)  Location dependency 
D)  Distributed locatability 
A)  Location transparency 
B)  Location autonomy 
C)  Location dependency 
D)  Distributed locatability

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is true about horizontal partitioning?

Accepted Answer

A)  Data can be stored to optimize local access. 
B)  Data are less secure. 
C)  There is consistent access speed. 
D)  It only works with Macintosh systems. 
A)  Data can be stored to optimize local access. 
B)  Data are less secure. 
C)  There is consistent access speed. 
D)  It only works with Macintosh systems.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A distributed database can be organized

Question 18

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

Accepted Answer

A)  Centralized; maximum 
B)  Centralized; minimum 
C)  Homogeneous; nonautonomous 
D)  Federated; nonautonomous 
A)  Centralized; maximum 
B)  Centralized; minimum 
C)  Homogeneous; nonautonomous 
D)  Federated; nonautonomous

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  link 
B)  tight 
C)  global 
D)  loose 
A)  link 
B)  tight 
C)  global 
D)  loose

An integrated partition strategy is ________ to manage.

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

Replication should NOT be used if timely updates are important.

Discuss the different types of data replication.

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

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

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

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

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

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

________ 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.

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

Which of the following is true about horizontal partitioning?

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

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

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

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

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

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

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

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

An integrated partition strategy is ________ to manage.

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

Replication should NOT be used if timely updates are important.

Discuss the different types of data replication.

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

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

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

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

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

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

________ 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.

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

Which of the following is true about horizontal partitioning?

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

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

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

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

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

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

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

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