Question 1

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

Question 2

Replicated databases usually result in tightly coupled nodes.

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which of the following factors in deciding on database distribution strategies is related to autonomy of organizational units?

Accepted Answer

A)  Organizational forces 
B)  Frequency of data access 
C)  Reliability needs 
D)  Organizational development 
A)  Organizational forces 
B)  Frequency of data access 
C)  Reliability needs 
D)  Organizational development

Question 6

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 7

What are the functions of a distributed DBMS?

Accepted Answer

In a distributed database environment, t

Question 8

A joining operation in which only the joining attribute from one site is transmitted to the other site is called a(n):

Accepted Answer

A)  attribute linkup. 
B)  key data element transfer. 
C)  key data element join. 
D)  semijoin. 
A)  attribute linkup. 
B)  key data element transfer. 
C)  key data element join. 
D)  semijoin.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Replication is often used for noncollaborative data.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

Replication should be used when:

Accepted Answer

A)  data currency and timing don't matter. 
B)  there is a highly heterogeneous network. 
C)  there are no or few triggers. 
D)  spreadsheet pages need to be linked. 
A)  data currency and timing don't matter. 
B)  there is a highly heterogeneous network. 
C)  there are no or few triggers. 
D)  spreadsheet pages need to be linked.

Question 14

Shared ownership of data is most appropriate as business activities move across time zones.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

In a homogeneous environment, the same DBMS is used at each location.

Accepted Answer

A) True 
 B)False

Question 19

A distributed unit of work does not support location transparency.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

Replicated databases usually result in tightly coupled nodes.

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

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

Which of the following factors in deciding on database distribution strategies is related to autonomy of organizational units?

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.

What are the functions of a distributed DBMS?

A joining operation in which only the joining attribute from one site is transmitted to the other site is called a(n):

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

Replication is often used for noncollaborative data.

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

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

Replication should be used when:

Shared ownership of data is most appropriate as business activities move across time zones.

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

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

Which of the following is true about horizontal partitioning?

In a homogeneous environment, the same DBMS is used at each location.

A distributed unit of work does not support location transparency.

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Data and Database Administration

Object-Oriented Data Modeling

Filters

Exam 13: Distributed Databases

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

Replicated databases usually result in tightly coupled nodes.

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

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

Which of the following factors in deciding on database distribution strategies is related to autonomy of organizational units?

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.

What are the functions of a distributed DBMS?

A joining operation in which only the joining attribute from one site is transmitted to the other site is called a(n):

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

Replication is often used for noncollaborative data.

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

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

Replication should be used when:

Shared ownership of data is most appropriate as business activities move across time zones.

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

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

Which of the following is true about horizontal partitioning?

In a homogeneous environment, the same DBMS is used at each location.

A distributed unit of work does not support location transparency.

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Data and Database Administration

Object-Oriented Data Modeling

Filters