Question 1

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 2

All of the following are advantages of horizontal partitioning EXCEPT:

Accepted Answer

A)  efficiency. 
B)  security. 
C)  ease of querying. 
D)  easier to set up than horizontal partitioning. 
A)  efficiency. 
B)  security. 
C)  ease of querying. 
D)  easier to set up than horizontal partitioning.

Question 3

A distributed unit of work allows a single SQL UPDATE statement to update data at more than one location.

Accepted Answer

A) True 
 B)False

Question 4

A distributed database must:

Accepted Answer

A)  keep track of data locations. 
B)  present a single logical database that is physically distributed. 
C)  require Oracle. 
D)  require SQL Server. 
A)  keep track of data locations. 
B)  present a single logical database that is physically distributed. 
C)  require Oracle. 
D)  require SQL Server.

Question 5

What business conditions encourage the use of distributed databases?

Accepted Answer

There are several business conditions wh

Question 6

With a pull strategy of replication, the ________ node determines when a database is updated.

Accepted Answer

A)  user 
B)  source 
C)  target 
D)  banner 
A)  user 
B)  source 
C)  target 
D)  banner

Question 7

________ is an application that can effectively employ snapshot replication in a distributed environment.

Accepted Answer

A)  Data cloning 
B)  Data replication 
C)  Distributed data 
D)  Data warehousing 
A)  Data cloning 
B)  Data replication 
C)  Distributed data 
D)  Data warehousing

Question 8

Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The sequence of instructions required to process a transaction is called the:

Accepted Answer

A)  unit of work. 
B)  logical program unit. 
C)  rollback. 
D)  commit. 
A)  unit of work. 
B)  logical program unit. 
C)  rollback. 
D)  commit.

Question 11

Simple paths to other databases without the benefits of one logical database are called:

Accepted Answer

A)  freeways. 
B)  parkways. 
C)  gateways. 
D)  highways. 
A)  freeways. 
B)  parkways. 
C)  gateways. 
D)  highways.

Question 12

A design goal for distributed databases to allow programmers to treat a data item replicated at several sites as though it were at one site is called:

Accepted Answer

A)  location transparency. 
B)  replication accessibility. 
C)  replication transparency. 
D)  data accessibility. 
A)  location transparency. 
B)  replication accessibility. 
C)  replication transparency. 
D)  data accessibility.

Question 13

When separate copies of data are stored at each of two or more sites, it is called replication.

Accepted Answer

A) True 
 B)False

Question 14

Replication is often used for noncollaborative data.

Accepted Answer

A) True 
 B)False

Question 15

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 16

A distributed database may require more costly and complex software than a centralized database.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following are business conditions that encourage the use of distributed databases?

Accepted Answer

A)  Companies with less than 10 employees 
B)  Lack of Data sharing needs 
C)  Data communication reliability 
D)  Companies that only store data on spreadsheets 
A)  Companies with less than 10 employees 
B)  Lack of Data sharing needs 
C)  Data communication reliability 
D)  Companies that only store data on spreadsheets

Question 18

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 19

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

A transaction manager is an algorithm that coordinates updates or aborts them.

Accepted Answer

A) True 
 B)False

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

All of the following are advantages of horizontal partitioning EXCEPT:

A distributed unit of work allows a single SQL UPDATE statement to update data at more than one location.

A distributed database must:

What business conditions encourage the use of distributed databases?

With a pull strategy of replication, the ________ node determines when a database is updated.

________ is an application that can effectively employ snapshot replication in a distributed environment.

Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.

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

The sequence of instructions required to process a transaction is called the:

Simple paths to other databases without the benefits of one logical database are called:

A design goal for distributed databases to allow programmers to treat a data item replicated at several sites as though it were at one site is called:

When separate copies of data are stored at each of two or more sites, it is called replication.

Replication is often used for noncollaborative data.

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

A distributed database may require more costly and complex software than a centralized database.

Which of the following are business conditions that encourage the use of distributed databases?

Replication should be used when:

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

A transaction manager is an algorithm that coordinates updates or aborts them.

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

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

All of the following are advantages of horizontal partitioning EXCEPT:

A distributed unit of work allows a single SQL UPDATE statement to update data at more than one location.

A distributed database must:

What business conditions encourage the use of distributed databases?

With a pull strategy of replication, the ________ node determines when a database is updated.

________ is an application that can effectively employ snapshot replication in a distributed environment.

Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.

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

The sequence of instructions required to process a transaction is called the:

Simple paths to other databases without the benefits of one logical database are called:

A design goal for distributed databases to allow programmers to treat a data item replicated at several sites as though it were at one site is called:

When separate copies of data are stored at each of two or more sites, it is called replication.

Replication is often used for noncollaborative data.

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

A distributed database may require more costly and complex software than a centralized database.

Which of the following are business conditions that encourage the use of distributed databases?

Replication should be used when:

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

A transaction manager is an algorithm that coordinates updates or aborts them.

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