Deck 12: Distributed Database Management Systems

Question 1

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

The level of transparency supported by the distributed database management system remains the same for all systems.

Answer 3

False

Question 4

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

Question 5

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

Question 6

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.

Question 7

A distributed database management system (DDBMS) must be communications-media-dependent.

Question 8

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

Question 9

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

Question 10

Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control.

Question 11

The transaction processor (TP) is the software component found in each computer that requests data.

Question 12

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

Question 13

Theweb is the repository for distributed data.

Question 14

One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand.

Question 15

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

Question 16

Distributed data access was needed to support geographically dispersed business units.

Question 17

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

Question 18

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

Question 19

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

Question 20

Distribution transparency is supported by a distributed data dictionary.

Question 21

_____ transparency 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 22

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

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

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

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

A) global index
B) data dictionary
C) global catalog
D) data thesaurus

Question 25

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

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

Question 26

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

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

Question 27

Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.

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 28

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

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

Question 29

_____ transparency allows the system to operate as if it were a centralized database management system.

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

Question 30

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

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

Question 31

A database management system needs _____ to prepare the data for presentation to the end user or to an application program.

A) security
B) concurrency control
C) formatting
D) I/O interface

Question 32

A disadvantage of a distributed database management system (DDBMS) is:

A) slower data access.
B) site additions affects other operations.
C) processor dependence.
D) lack of standards.

Question 33

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

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

Question 34

In theory, a(n) _____ can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

A) transaction processor
B) application processor
C) transaction manager
D) data processor

Question 35

_____ 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 36

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

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

Question 37

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

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

Question 38

A DDBMS is subject to which restriction?

A) Multiple instances of the same database should be integrated over a network.
B) All database processing must be done at a single site.
C) Rapid ad hoc data access is not possible.
D) Remote data access is provided on a read-only basis.

Question 39

Distributed processing does not require:

A) processing function distribution to all storage sites.
B) an existing distributed database.
C) interconnected networks of components.
D) multiple sites to share processing chores.

Question 40

A centralized database management is subject to a problem such as _____.

A) growing numbers of remote locations
B) maintaining and operating small database systems
C) dependence on multiple sites
D) organizational flexibility of the database

Question 41

A user-friendly _____ is one advantage of a distributed database management system (DDBMS) .

Question 42

_____ fragmentation allows a user to break a single object into two or more segments, or fragments.

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

Question 43

A transaction processor is also known as the _____ processor.

Question 44

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

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

Question 45

In a distributed database management system (DDBMS), _____ control is used to manage simultaneous data access and ensure data consistency across database fragments.

Question 46

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

Question 47

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

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

Question 48

In a distributed database management system (DDBMS), _____ occurs to determine the data location of local and remote fragments.

Question 49

_____ management ensures that data move from one consistent state to another.

Question 50

In a distributed database management system (DDBMS), query _____ is used to find the best access strategy.

Question 51

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 52

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

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

Question 53

Which propertyof the CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database?

A) Consistency
B) Partition tolerance
C) Availability
D) Performance transparency

Question 54

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 55

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

Question 56

During_____ data allocation, the database is divided into two or more disjointed parts (fragments) and stored at two or more sites.

A) mixed
B) replicated
C) centralized
D) partitioned

Question 57

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

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

Question 58

One of the advantages of a distributed database management system (DDBMS) is less danger of a single-_____ failure.

Question 59

_____ 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 60

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a(n) _____.

Question 61

The _____ forces the log entry to be written to permanent storage before the actual operation takes place.

Question 62

Explain the three types of operations defined by the DO-UNDO-REDO protocol.

Question 63

The distributed database system must be _____ of the computer system hardware.

Question 64

During _____replication, after an update, the originating DP node sends "messages" to the replica nodes to notify them of the update.

Question 65

The _____ protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

Question 66

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

Question 67

Data _____ describes the process of deciding where to locate data.

Question 68

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

Question 69

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

Question 70

Explain the difference between homogeneous and heterogeneous distributed database management systems (DDBMS).

Question 71

Describe performance transparency and heterogeneity transparency.

Question 72

After an update, the originating DP node sends the changes to the replica nodes to ensure that data is immediately updated, during _____replication.

Question 73

The _____ fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is located.

Question 74

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?