Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The __________________________________________________ scenario is typical of most mainframe and midrange server computer DBMSs.

Accepted Answer

single-site processi

Question 3

____ fragmentation allows you to break a single object into two or more segments or fragments.

Accepted Answer

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

Question 4

A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.

Accepted Answer

A)  fully heterogeneous 
B)  fully homogeneous 
C)  homogeneous 
D)  heterogeneous 
A)  fully heterogeneous 
B)  fully homogeneous 
C)  homogeneous 
D)  heterogeneous

Question 5

A distributed ____ allows a transaction to reference several different remote database processing sites.

Accepted Answer

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

Question 6

____ 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 7

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

Accepted Answer

A) True 
 B)False

Question 8

____ query optimization takes place at compilation time.

Accepted Answer

A)  Dynamic 
B)  Static 
C)  Automatic 
D)  Manual 
A)  Dynamic 
B)  Static 
C)  Automatic 
D)  Manual

Question 9

The TP is the software component found in each computer that requests data.

Accepted Answer

A) True 
 B)False

Question 10

The ____ processor is the software component found in each computer that requests data.It receives and processes the application's data requests.

Accepted Answer

A)  database 
B)  transaction 
C)  data 
D)  network 
A)  database 
B)  transaction 
C)  data 
D)  network

Question 11

One of the advantages of a DDBMS is security.

Accepted Answer

A) True 
 B)False

Question 12

One of the advantages of a DDBMS is improved communication.

Accepted Answer

A) True 
 B)False

Question 13

____ transparency allows the integration of several different local DBMSs under a common,or global,schema.

Accepted Answer

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

Question 14

____________________ management ensures that data move from one consistent state to another,including synchronization of local and remote transactions.

Accepted Answer

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

Question 15

____ query optimization takes place at execution time.

Accepted Answer

A)  Automatic 
B)  Static 
C)  Manual 
D)  Dynamic 
A)  Automatic 
B)  Static 
C)  Manual 
D)  Dynamic

Question 16

One of the advantages of a DDBMS is processor ____________________.

Accepted Answer

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

Question 17

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

Accepted Answer

A)  multiple-site processing,single-site data 
B)  single-site processing,multiple-site data 
C)  single-site processing,single-site data 
D)  multiple-site processing,multiple-site data 
A)  multiple-site processing,single-site data 
B)  single-site processing,multiple-site data 
C)  single-site processing,single-site data 
D)  multiple-site processing,multiple-site data

Question 18

Distributed processing shares the database's logical processing among two or more physically independent sites that are connected through a network.

Accepted Answer

A) True 
 B)False

Question 19

The inherently complex distributed data environment increases the urgency for standard protocols governing transaction management.

Accepted Answer

A) True 
 B)False

Question 20

____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

Accepted Answer

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

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

The __________________________________________________ scenario is typical of most mainframe and midrange server computer DBMSs.

____ fragmentation allows you to break a single object into two or more segments or fragments.

A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.

A distributed ____ allows a transaction to reference several different remote database processing sites.

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

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

____ query optimization takes place at compilation time.

The TP is the software component found in each computer that requests data.

The ____ processor is the software component found in each computer that requests data.It receives and processes the application's data requests.

One of the advantages of a DDBMS is security.

One of the advantages of a DDBMS is improved communication.

____ transparency allows the integration of several different local DBMSs under a common,or global,schema.

____________________ management ensures that data move from one consistent state to another,including synchronization of local and remote transactions.

____ query optimization takes place at execution time.

One of the advantages of a DDBMS is processor ____________________.

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

Distributed processing shares the database's logical processing among two or more physically independent sites that are connected through a network.

The inherently complex distributed data environment increases the urgency for standard protocols governing transaction management.

____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

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

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

The __________________________________________________ scenario is typical of most mainframe and midrange server computer DBMSs.

____ fragmentation allows you to break a single object into two or more segments or fragments.

A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.

A distributed ____ allows a transaction to reference several different remote database processing sites.

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

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

____ query optimization takes place at compilation time.

The TP is the software component found in each computer that requests data.

The ____ processor is the software component found in each computer that requests data.It receives and processes the application's data requests.

One of the advantages of a DDBMS is security.

One of the advantages of a DDBMS is improved communication.

____ transparency allows the integration of several different local DBMSs under a common,or global,schema.

____________________ management ensures that data move from one consistent state to another,including synchronization of local and remote transactions.

____ query optimization takes place at execution time.

One of the advantages of a DDBMS is processor ____________________.

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

Distributed processing shares the database's logical processing among two or more physically independent sites that are connected through a network.

The inherently complex distributed data environment increases the urgency for standard protocols governing transaction management.

____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

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