Question 1

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

Accepted Answer

A distributed database can be organized

Question 2

The reliability of a decentralized distributed database system with independent partitions is poor.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

In general, data should be located away from the applications that use those data.

Accepted Answer

A) True 
 B)False

Question 5

With a two-phase commit strategy for synchronizing distributed data, committing a transaction is faster than if the originating location were able to work alone.

Accepted Answer

A) True 
 B)False

Question 6

One way to generate messages for near-real-time replication is through the use of database triggers.

Accepted Answer

A) True 
 B)False

Question 7

What is horizontal and vertical partitioning?

Accepted Answer

With horizontal partitioning, some of th

Question 8

Which of the following characterizes homogeneous environments?

Accepted Answer

A)  Contains simple pathways 
B)  Same DBMS used at all locations 
C)  Some users require only local access 
D)  Cross-linked systems easily communicate 
A)  Contains simple pathways 
B)  Same DBMS used at all locations 
C)  Some users require only local access 
D)  Cross-linked systems easily communicate

Question 9

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

Question 10

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 11

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

Accepted Answer

A)  stored procedures. 
B)  triggers. 
C)  functions. 
D)  SQL statements. 
A)  stored procedures. 
B)  triggers. 
C)  functions. 
D)  SQL statements.

Question 12

Replication should NOT be used if timely updates are important.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following environments uses a different DBMS at each node and supports local databases for unique data requests?

Accepted Answer

A)  Gateways; local 
B)  Centralized; minimum 
C)  Homogeneous; cross-linked 
D)  Heterogeneous; federated 
A)  Gateways; local 
B)  Centralized; minimum 
C)  Homogeneous; cross-linked 
D)  Heterogeneous; federated

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

With ________, users can act as if all the data were located at a single node.

Accepted Answer

A)  location transparency 
B)  local autonomy 
C)  client-based control 
D)  location consistency 
A)  location transparency 
B)  local autonomy 
C)  client-based control 
D)  location consistency

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

________ ensures that a transaction is successfully completed or else it is aborted.

Accepted Answer

A)  Failure protocol 
B)  TCP/IP protocol 
C)  Commit protocol 
D)  Go/No Go protocol 
A)  Failure protocol 
B)  TCP/IP protocol 
C)  Commit protocol 
D)  Go/No Go protocol

Question 18

The overriding principle in distributed database design is that data should be stored at one central site.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

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

The reliability of a decentralized distributed database system with independent partitions is poor.

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

In general, data should be located away from the applications that use those data.

With a two-phase commit strategy for synchronizing distributed data, committing a transaction is faster than if the originating location were able to work alone.

One way to generate messages for near-real-time replication is through the use of database triggers.

What is horizontal and vertical partitioning?

Which of the following characterizes homogeneous environments?

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

An integrated partition strategy is ________ to manage.

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

Replication should NOT be used if timely updates are important.

Which of the following environments uses a different DBMS at each node and supports local databases for unique data requests?

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

With ________, users can act as if all the data were located at a single node.

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

________ ensures that a transaction is successfully completed or else it is aborted.

The overriding principle in distributed database design is that data should be stored at one central site.

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 local transaction is one that requires reference only to data that are stored at the site where the transaction originates.

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

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

The reliability of a decentralized distributed database system with independent partitions is poor.

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

In general, data should be located away from the applications that use those data.

With a two-phase commit strategy for synchronizing distributed data, committing a transaction is faster than if the originating location were able to work alone.

One way to generate messages for near-real-time replication is through the use of database triggers.

What is horizontal and vertical partitioning?

Which of the following characterizes homogeneous environments?

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

An integrated partition strategy is ________ to manage.

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

Replication should NOT be used if timely updates are important.

Which of the following environments uses a different DBMS at each node and supports local databases for unique data requests?

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

With ________, users can act as if all the data were located at a single node.

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

________ ensures that a transaction is successfully completed or else it is aborted.

The overriding principle in distributed database design is that data should be stored at one central site.

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 local transaction is one that requires reference only to data that are stored at the site where the transaction originates.

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