Deck 12: Distributed Database Management Systems

Question 1

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

Answer 1

True

Question 2

One of the advantages of a DDBMS is security.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

Question 7

One of the advantages of a DDBMS is growth facilitation.

Question 8

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

Question 9

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

Question 10

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

Question 11

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

Question 12

One of the advantages of a DDBMS is improved communication.

Question 13

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

Question 14

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.

Question 15

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

Question 16

Current DDBMSs are subject to some problems,such as the complexity of management and control.

Question 17

A DDBMS must be communications-media-dependent.

Question 18

A transaction processor is the software component residing on each computer that stores and retrieves data located at the site.

Question 19

A distributed database system requires functional characteristics that can be grouped and described as transparency features.

Question 20

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

Question 21

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

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

Question 22

____ 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) Transaction
B) Location
C) Local mapping
D) Fragmentation

Question 23

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

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

Question 24

____ is a disadvantage of a DDBMS.

A) Data is located near the "greatest demand" site
B) Growth facilitation
C) Danger of a single-point failure
D) Lack of standards

Question 25

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

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

Question 26

The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.

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

Question 27

____ transparency allows a distributed database to be treated as a single logical database.

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

Question 28

____ is a disadvantage of a DDBMS.

A) Processor independence
B) User-friendly interface
C) Security
D) Faster data access

Question 29

____ distributed database systems integrate only one type of centralized DBMS over a network.

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

Question 30

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

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 31

____ is an advantage of a DDBMS.

A) Reduced operating cost
B) Simplicity of management and control
C) Decreased storage requirements
D) Decreased training cost

Question 32

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

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 33

____ transparency allows a transaction to update data at several network sites.

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

Question 34

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

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

Question 35

____ transparency ensures that the system will continue to operate in the event of a node failure.

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

Question 36

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

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

Question 37

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

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

Question 38

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

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

Question 39

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

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

Question 40

A ____ contains the description of the entire database as seen by the database administrator.

A) distributed global dictionary
B) distributed data dictionary
C) distributed global schema
D) distributed data schema

Question 41

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

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

Question 42

One of the advantages of a DDBMS is processor ____________________.

Question 43

A ____ query optimization algorithm is based on a set of user-defined rules to determine the best access strategy.

A) statistically based
B) rule-based
C) manual
D) dynamic

Question 44

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

Question 45

____ query optimization takes place at execution time.

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

Question 46

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

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

Question 47

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

Question 48

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

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

Question 49

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

Question 50

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

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

Question 51

One of the advantages of a DDBMS is ____________________ operating cost.

Question 52

A transaction processor is also known as the ____________________ processor.

Question 53

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

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

Question 54

____ query optimization takes place at compilation time.

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

Question 55

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

Question 56

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

Question 57

A user-friendly ____________________ is one advantage of a DDBMS.

Question 58

In a DDBMS,____________________ occurs to determine the data location of local and remote fragments.

Question 59

____ query optimization means that the DDBMS finds the most cost-effective access path without user intervention.

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

Question 60

What is a disadvantage of client/server applications?

A) There are more people with PC skills than with mainframe skills in the job market.
B) The PC is not well established in the workplace.
C) An increase in the number of users and processing sites often paves the way for security problems.
D) There is a considerable cost disadvantage to offloading applications development from the mainframe to powerful PCs.

Question 61

Describe performance transparency and heterogeneity transparency.

Question 62

The ____________________ fragment condition indicates that each row is unique,regardless of the fragment in which it is located.

Question 63

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

Question 64

Explain heterogeneous distributed database systems.

Question 65

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

Question 66

The ____________________ commit protocol 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.

Question 67

What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?

Question 68

The DO-UNDO-REDO protocol defines three types of operations.What are they?

Question 69

If a DDBMS exhibits ____________________ transparency,the user does not need to know that the data are partitioned-meaning the table's rows and columns are split vertically or horizontally and stored among multiple sites.

Question 70

Typically,the __________________________________________________ scenario requires a network file server running conventional applications that are accessed through a network.