Deck 12: Distributed Database Management Systems

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

One of the advantages of a DDBMS is improved communication.

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

A DDBMS must be communications-media-dependent.

Question 9

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

Question 10

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

Question 11

One of the advantages of a DDBMS is security.

Question 12

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

Question 13

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

Question 14

One of the advantages of a DDBMS is growth facilitation.

Question 15

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

Question 16

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

Question 17

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 18

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

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 23

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

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

____ is a disadvantage of a DDBMS.

A) Processor independence
B) The graphical user interface
C) Security
D) Data access that is too rapid

Question 26

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 27

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

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

Question 28

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

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

Question 29

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 30

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

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

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

Question 32

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

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

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

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

Question 36

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 37

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

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

Question 38

____ are an advantage of a DDBMS.

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

Question 39

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 40

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

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

Question 41

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

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

Question 42

A(n)____ database stores each database fragment at a single site.

A) partially replicated
B) unreplicated
C) fully replicated
D) partitioned

Question 43

A transaction processor is also known as the ____________________ processor.

Question 44

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

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

Question 45

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

Question 46

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

Question 47

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

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

Question 48

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

Question 49

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

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

Question 50

One of the advantages of a DDBMS is processor ____________________.

Question 51

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

Question 52

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

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

Question 53

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

Question 54

____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.

A) Data distribution
B) Replica transparency
C) Network latency
D) Network partitioning

Question 55

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

Question 56

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.

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

Question 57

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

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

Question 58

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

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

Question 59

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

Question 60

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

Question 61

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 62

Describe performance transparency and heterogeneity transparency.

Question 63

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

Question 64

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

Question 65

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

Question 66

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 67

Explain heterogeneous distributed database systems.

Question 68

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 69

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

Question 70

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.