Question 1

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

Question 2

Explain heterogeneous distributed database systems.

Accepted Answer

Homogeneous DDBMSs integrate multiple instances of the same DBMS over a network-for example,multiple instances of Oracle 11g running on different platforms.In contrast,heterogeneous DDBMSs integrate different types of DBMSs over a network,but all support the same data model.A fully heterogeneous DDBMS will support different DBMSs,each one supporting a different data model,running under different computer systems.

Question 3

____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

Accepted Answer

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

Question 4

A distributed database is composed of several parts known as database ____.

Accepted Answer

A)  sections 
B)  fragments 
C)  partitions 
D)  parts 
A)  sections 
B)  fragments 
C)  partitions 
D)  parts

Question 5

One of the advantages of a DDBMS is improved communication.

Accepted Answer

A) True 
 B)False

Question 6

The objective of ____ optimization is to minimize the total cost associated with the execution of a request.

Accepted Answer

A)  data 
B)  remote 
C)  transaction 
D)  query 
A)  data 
B)  remote 
C)  transaction 
D)  query

Question 7

A fully distributed 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 8

Under the ____ scenario,multiple processes run on different computers sharing a single data repository.

Accepted Answer

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

Question 9

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 10

Both distributed processing and distributed databases require a network to connect all components.

Accepted Answer

A) True 
 B)False

Question 11

One of the advantages of a DDBMS is security.

Accepted Answer

A) True 
 B)False

Question 12

A DBMS must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

Accepted Answer

A) True 
 B)False

Question 13

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

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 15

The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

Accepted Answer

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

Question 16

____ distributed database systems integrate different types of centralized DBMSs 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

The World Wide Web (the Web)is the repository for distributed data.

Accepted Answer

A) True 
 B)False

Question 18

In a DDBMS,query ____________________ is used to find the best access strategy.

Accepted Answer

The answer of In a DDBMS,query ____________________ is used to...

Question 19

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

Accepted Answer

single-site processi

Question 20

In a DDBMS,____________________ control is used to manage simultaneous data access and ensure data consistency across database fragments.

Accepted Answer

The answer of In a DDBMS,____________________ control is used to...

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

Explain heterogeneous distributed database systems.

____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

A distributed database is composed of several parts known as database ____.

One of the advantages of a DDBMS is improved communication.

The objective of ____ optimization is to minimize the total cost associated with the execution of a request.

A fully distributed 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.

Under the ____ scenario,multiple processes run on different computers sharing a single data repository.

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

Both distributed processing and distributed databases require a network to connect all components.

One of the advantages of a DDBMS is security.

A DBMS must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

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

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

The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

____ distributed database systems integrate different types of centralized DBMSs over a network.

The World Wide Web (the Web)is the repository for distributed data.

In a DDBMS,query ____________________ is used to find the best access strategy.

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

In a DDBMS,____________________ control is used to manage simultaneous data access and ensure data consistency across database fragments.

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

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

Explain heterogeneous distributed database systems.

____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

A distributed database is composed of several parts known as database ____.

One of the advantages of a DDBMS is improved communication.

The objective of ____ optimization is to minimize the total cost associated with the execution of a request.

A fully distributed 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.

Under the ____ scenario,multiple processes run on different computers sharing a single data repository.

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

Both distributed processing and distributed databases require a network to connect all components.

One of the advantages of a DDBMS is security.

A DBMS must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

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

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

The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

____ distributed database systems integrate different types of centralized DBMSs over a network.

The World Wide Web (the Web)is the repository for distributed data.

In a DDBMS,query ____________________ is used to find the best access strategy.

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

In a DDBMS,____________________ control is used to manage simultaneous data access and ensure data consistency across database fragments.

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