Question 1

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 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

A distributed database management system (DDBMS)governs the storage and processing of logically related data over interconnected computer systems.

Accepted Answer

A) True 
 B)False

Question 5

_____ distributed database management system (DDBMS)integrate multiple instances of the same DBMS over a network.

Accepted Answer

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

Question 6

In order to manage distributed data,copies or parts of the database processing functions must be distributed to all data storage sites.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

single-site processi

Question 8

Distributed processing does not require:

Accepted Answer

A) database processing functions to be distributed to all data storage sites. 
B) an existing distributed database. 
C) a network of interconnected components. 
D) multiple sites to share processing chores. 
A) database processing functions to be distributed to all data storage sites. 
B) an existing distributed database. 
C) a network of interconnected components. 
D) multiple sites to share processing chores.

Question 9

A lets a single SQL statement access the data that are to be processed by a single remote database processor.

Accepted Answer

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

Question 10

A fully distributed database management system (DBMS)must perform all the functions of a centralized DBMS,and it must handle all necessary functions imposed by the distribution of data and processing.

Accepted Answer

A) True 
 B)False

Question 11

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 schema,is...

Question 12

Distribution transparency is supported by a distributed data dictionary.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The rule requires that all copies of data fragments be identical.

Accepted Answer

A) shared fragment 
B) mutual consistency 
C) horizontal fragmentation 
D) replication 
A) shared fragment 
B) mutual consistency 
C) horizontal fragmentation 
D) replication

Question 15

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

Accepted Answer

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

Question 16

transparency allows a physically dispersed database to be managed as though it were centralized.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

fragmentation refers to the division of a relation into attribute subsets.

Accepted Answer

A) Data 
B) Horizontal 
C) Vertical 
D) Mixed 
A) Data 
B) Horizontal 
C) Vertical 
D) Mixed

Question 19

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 20

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

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

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

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

A distributed database management system (DDBMS)governs the storage and processing of logically related data over interconnected computer systems.

_____ distributed database management system (DDBMS)integrate multiple instances of the same DBMS over a network.

In order to manage distributed data,copies or parts of the database processing functions must be distributed to all data storage sites.

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

Distributed processing does not require:

A lets a single SQL statement access the data that are to be processed by a single remote database processor.

A fully distributed database management system (DBMS)must perform all the functions of a centralized DBMS,and it must handle all necessary functions imposed by the distribution of data and processing.

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

Distribution transparency is supported by a distributed data dictionary.

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

The rule requires that all copies of data fragments be identical.

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

transparency allows a physically dispersed database to be managed as though it were centralized.

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

fragmentation refers to the division of a relation into attribute subsets.

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

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 12: Distributed Database Management Systems

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

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

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

A distributed database management system (DDBMS)governs the storage and processing of logically related data over interconnected computer systems.

_____ distributed database management system (DDBMS)integrate multiple instances of the same DBMS over a network.

In order to manage distributed data,copies or parts of the database processing functions must be distributed to all data storage sites.

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

Distributed processing does not require:

A lets a single SQL statement access the data that are to be processed by a single remote database processor.

A fully distributed database management system (DBMS)must perform all the functions of a centralized DBMS,and it must handle all necessary functions imposed by the distribution of data and processing.

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

Distribution transparency is supported by a distributed data dictionary.

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

The rule requires that all copies of data fragments be identical.

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

transparency allows a physically dispersed database to be managed as though it were centralized.

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

fragmentation refers to the division of a relation into attribute subsets.

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

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters