Question 1

transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

Accepted Answer

A)  Performance 
B)  Fragmentation 
C)  Location 
D)  Local mapping 
A)  Performance 
B)  Fragmentation 
C)  Location 
D)  Local mapping

Question 2

One of the advantages of a distributed database management system (DDBMS) is growth facilitation.

Accepted Answer

A) True 
 B)False

Question 3

A fully distributed database management system must perform all of the functions of a centralized database management system (DBMS). What are these functions?

Accepted Answer

1. Receive the request of an application

Question 4

A disadvantage of a distributed database management system (DDBMS) is that:

Accepted Answer

A)  it is slower in terms of data access. 
B)  adding new sites affects other sites' operations. 
C)  it is processor dependent. 
D)  there are lack of standards. 
A)  it is slower in terms of data access. 
B)  adding new sites affects other sites' operations. 
C)  it is processor dependent. 
D)  there are lack of standards.

Question 5

The fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is located.

Accepted Answer

The answer of The fragment condition indicates that no row...

Question 6

One of the advantages of a distributed database management system (DDBMS) is processor .

Accepted Answer

The answer of One of the advantages of a distributed...

Question 7

transparency allows data to be updated simultaneously at several network sites.

Accepted Answer

A)  Transaction 
B)  Distribution 
C)  Failure 
D)  Performance 
A)  Transaction 
B)  Distribution 
C)  Failure 
D)  Performance

Question 8

A remote transaction, composed of several requests, may access data at multiple sites.

Accepted Answer

A) True 
 B)False

Question 9

transparency allows the system to operate as if it were a centralized database management system.

Accepted Answer

A)  Heterogeneity 
B)  Distribution 
C)  Performance 
D)  Failure 
A)  Heterogeneity 
B)  Distribution 
C)  Performance 
D)  Failure

Question 10

management ensures that data move from one consistent state to another.

Accepted Answer

The answer of management ensures that data move from one...

Question 11

Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.

Accepted Answer

A) True 
 B)False

Question 12

A request lets a single SQL statement reference data located at several different local or remote DP sites.

Accepted Answer

A)  distributed 
B)  transaction 
C)  fragmented 
D)  remote 
A)  distributed 
B)  transaction 
C)  fragmented 
D)  remote

Question 13

The database description, known as the distributed schema, is the common database schema used by local transaction processors (TPs) to translate user requests into subqueries that will be processed by different data processors (DPs).

Accepted Answer

The answer of The database description, known as the distributed...

Question 14

The scenario is typical of most mainframe and midrange UNIX/LINUX server database management systems (DBMS).

Accepted Answer

single-site processi

Question 15

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

Accepted Answer

A) True 
 B)False

Question 16

distributed database systems integrate different types of centralized database management systems (DBMS) over a network.

Accepted Answer

A)  Homogeneous 
B)  Heterogeneous 
C)  Fully homogeneous 
D)  Combination 
A)  Homogeneous 
B)  Heterogeneous 
C)  Fully homogeneous 
D)  Combination

Question 17

In a distributed database management system (DDBMS), occurs to determine the data location of local and remote fragments.

Accepted Answer

The answer of In a distributed database management system (DDBMS),...

Question 18

A distributed can reference several different local or remote data processing sites.

Accepted Answer

A)  request 
B)  site 
C)  data location 
D)  transaction 
A)  request 
B)  site 
C)  data location 
D)  transaction

Question 19

The guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.

Accepted Answer

A)  DO-UNDO-REDO protocol 
B)  two-phase commit protocol (2P
C)  
C)  coordinator protocol 
D)  write-ahead protocol 
A)  DO-UNDO-REDO protocol 
B)  two-phase commit protocol (2P
C)  
C)  coordinator protocol 
D)  write-ahead protocol

Question 20

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

Accepted Answer

A) True 
 B)False

transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

One of the advantages of a distributed database management system (DDBMS) is growth facilitation.

A fully distributed database management system must perform all of the functions of a centralized database management system (DBMS). What are these functions?

A disadvantage of a distributed database management system (DDBMS) is that:

The fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is located.

One of the advantages of a distributed database management system (DDBMS) is processor .

transparency allows data to be updated simultaneously at several network sites.

A remote transaction, composed of several requests, may access data at multiple sites.

transparency allows the system to operate as if it were a centralized database management system.

management ensures that data move from one consistent state to another.

Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.

A request lets a single SQL statement reference data located at several different local or remote DP sites.

The database description, known as the distributed schema, is the common database schema used by local transaction processors (TPs) to translate user requests into subqueries that will be processed by different data processors (DPs).

The scenario is typical of most mainframe and midrange UNIX/LINUX server database management systems (DBMS).

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

distributed database systems integrate different types of centralized database management systems (DBMS) over a network.

In a distributed database management system (DDBMS), occurs to determine the data location of local and remote fragments.

A distributed can reference several different local or remote data processing sites.

The guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 12: Distributed Database Management Systems

transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

One of the advantages of a distributed database management system (DDBMS) is growth facilitation.

A fully distributed database management system must perform all of the functions of a centralized database management system (DBMS). What are these functions?

A disadvantage of a distributed database management system (DDBMS) is that:

The fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is located.

One of the advantages of a distributed database management system (DDBMS) is processor .

transparency allows data to be updated simultaneously at several network sites.

A remote transaction, composed of several requests, may access data at multiple sites.

transparency allows the system to operate as if it were a centralized database management system.

management ensures that data move from one consistent state to another.

Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.

A request lets a single SQL statement reference data located at several different local or remote DP sites.

The database description, known as the distributed schema, is the common database schema used by local transaction processors (TPs) to translate user requests into subqueries that will be processed by different data processors (DPs).

The scenario is typical of most mainframe and midrange UNIX/LINUX server database management systems (DBMS).

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

distributed database systems integrate different types of centralized database management systems (DBMS) over a network.

In a distributed database management system (DDBMS), occurs to determine the data location of local and remote fragments.

A distributed can reference several different local or remote data processing sites.

The guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters