CIS 1200 Ch 12 – Flashcards
Unlock all answers in this set
Unlock answersquestion
Distributed data access was needed to support geographically dispersed business units.
answer
True
question
Rapid ad hoc data became unnecessary in the quick-response decision-making environment.
answer
False
question
A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems.
answer
True
question
The World Wide Web is the repository for distributed data.
answer
True
question
One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand.
answer
False
question
One of the advantages of a distributed database management system (DDBMS) is growth facilitation.
answer
True
question
One of the advantages of a distributed database management system (DDBMS) is improved communication.
answer
True
question
One of the advantages of a distributed database management system (DDBMS) is security.
answer
False
question
Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control.
answer
True
question
Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.
answer
True
question
Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.
answer
False
question
In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.
answer
True
question
Both distributed processing and distributed databases require a network of interconnected components.
answer
True
question
A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.
answer
True
question
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.
answer
True
question
The transaction processor (TP) is the software component found in each computer that requests data.
answer
True
question
A distributed database management system (DDBMS) must be communications-media-dependent.
answer
False
question
A transaction processor (TP) is the software component residing on each computer that stores and retrieves data located at the site.
answer
False
question
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
False
question
Performance transparency ensures that the system finds the most cost-effective path to access remote data.
answer
True
question
Distribution transparency is supported by a distributed data dictionary.
answer
True
question
The level of transparency supported by the distributed database management system remains the same for all systems.
answer
False
question
Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
answer
False
question
A remote transaction, composed of several requests, may access data at multiple sites.
answer
False
question
A centralized database management is subject to a problem such as __________. a. a growing number of remote locations b. maintaining and operating small database systems c. dependence on multiple sites d. organizational flexibility of the database
answer
a. a growing number of remote locations
question
A disadvantage of a distributed database management system (DDBMS) is that: a. it is slower in terms of data access. b. adding new sites affects other sites' operations. c. it is processor dependent. d. there are lack of standards.
answer
d. there are lack of standards.
question
__________ is a disadvantage of a distributed database management system (DDBMS). a. Processor dependence b. Lack of graphical user interface c. Security lapse d. Increased danger of a single-point failure
answer
c. Security lapse
question
Which of the following is an advantage associated with a distributed database management system (DDBMS)? a. Reduced operating costs b. Simplicity of management and control c. Decreased storage requirements d. Decreased training costs
answer
a. Reduced operating costs
question
A distributed database is composed of several parts known as database __________. a. sections b. fragments c. partitions d. parts
answer
b. fragments
question
Distributed processing does not require: a. database processing functions to be distributed to all data storage sites. b. an existing distributed database. c. a network of interconnected components. d. multiple sites to share processing chores.
answer
b. an existing distributed database.
question
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
answer
c. formatting
question
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
answer
b. transaction
question
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
answer
d. data processor
question
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
answer
c. data
question
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
answer
b. multiple-site processing, single-site data
question
A DDBMS is subject to which of the following restrictions? 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.
answer
d. Remote data access is provided on a read-only basis.
question
_____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network. a. Homogeneous b. Heterogeneous c. Fully heterogeneous d. Combination
answer
a. Homogeneous
question
__________ distributed database systems integrate different types of centralized database management systems (DBMS) over a network. a. Homogeneous b. Heterogeneous c. Fully homogeneous d. Combination
answer
b. Heterogeneous
question
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
answer
a. fully heterogeneous
question
__________ transparency allows a physically dispersed database to be managed as though it were centralized. a. Distribution b. Transaction c. Failure d. Performance
answer
a. Distribution
question
__________ transparency allows data to be updated simultaneously at several network sites. a. Transaction b. Distribution c. Failure d. Performance
answer
a. Transaction
question
__________ transparency ensures that the system will continue to operate in the event of a node or network malfunction. a. Transaction b. Distribution c. Failure d. Performance
answer
c. Failure
question
__________ transparency allows the system to operate as if it were a centralized database management system. a. Heterogeneity b. Distribution c. Performance d. Failure
answer
c. Performance
question
__________ transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema. a. Transaction b. Performance c. Distribution d. Heterogeneity
answer
d. Heterogeneity
question
__________ 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
answer
b. Fragmentation
question
__________ 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
answer
b. Location
question
__________ 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. Fragmentation
answer
a. Local mapping
question
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
answer
b. distributed data dictionary
question
A distributed __________ can reference several different local or remote data processing sites. a. request b. site c. data location d. transaction
answer
d. transaction
question
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
answer
a. distributed
question
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
answer
b. two-phase commit protocol (2PC)
question
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
answer
a. remote request
question
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
answer
d. query
question
__________ 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
answer
c. Network latency
question
__________ fragmentation allows a user to break a single object into two or more segments, or fragments. a. Horizontal b. Vertical c. Data d. Request
answer
c. Data
question
__________ fragmentation refers to the division of a relation into subsets of tuples. a. Vertical b. Horizontal c. Data d. Mixed
answer
b. Horizontal
question
__________ fragmentation refers to the division of a relation into attribute subsets. a. Data b. Horizontal c. Vertical d. Mixed
answer
c. Vertical
question
The __________ rule requires that all copies of data fragments be identical. a. shared fragment b. mutual consistency c. horizontal fragmentation d. replication
answer
b. mutual consistency
question
A(n) __________ database stores each database fragment at a single site. a. partially replicated b. unreplicated c. fully replicated d. partitioned
answer
b. unreplicated
