Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

All of the following are disadvantages of data replication EXCEPT:

Accepted Answer

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

Question 3

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

Question 4

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

Accepted Answer

The answer of Simple paths to other databases without the...

Question 5

A form of distributed database in which all data across a network are kept continuously updated,so a user can access any data anywhere on the network and get the same answer is called a(n)________ distributed database.

Accepted Answer

The answer of A form of distributed database in which...

Question 6

Replication is often used for noncollaborative data.

Accepted Answer

A) True 
 B)False

Question 7

Local autonomy means that data are not accessible from remote sites.

Accepted Answer

A) True 
 B)False

Question 8

The ________ at each site maintains an appropriate concurrency scheme to ensure data integrity during parallel execution of transactions at that site.

Accepted Answer

The answer of The ________ at each site maintains an...

Question 9

________ is a design goal for a distributed database that says a site can independently administer and operate its database.

Accepted Answer

The answer of ________ is a design goal for a...

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

All of the following are disadvantages of data replication EXCEPT:

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

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

A form of distributed database in which all data across a network are kept continuously updated,so a user can access any data anywhere on the network and get the same answer is called a(n)________ distributed database.

Replication is often used for noncollaborative data.

Local autonomy means that data are not accessible from remote sites.

The ________ at each site maintains an appropriate concurrency scheme to ensure data integrity during parallel execution of transactions at that site.

________ is a design goal for a distributed database that says a site can independently administer and operate its database.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

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

Data and Database Administration

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 12: Distributed Databases

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

All of the following are disadvantages of data replication EXCEPT:

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

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

A form of distributed database in which all data across a network are kept continuously updated,so a user can access any data anywhere on the network and get the same answer is called a(n)________ distributed database.

Replication is often used for noncollaborative data.

Local autonomy means that data are not accessible from remote sites.

The ________ at each site maintains an appropriate concurrency scheme to ensure data integrity during parallel execution of transactions at that site.

________ is a design goal for a distributed database that says a site can independently administer and operate its database.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

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

Data and Database Administration

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters