Distributed Databases, Chapter 14

The ____ contains the description of the entire database as seen by the database administrator.
1. distributed global dictionary
2. distributed data dictionary
3. distributed global schema
4. distributed data schema
____ 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.
1. Transaction
2. Location
3. Local mapping
4. Fragmentation
____ transparency ensures that the system will continue to operate in the event of a node failure.
1. Transaction
2. Distribution
3. Failure
4. Performance
The ____ rule requires that all copies of data fragments be identical.
1. shared fragment
2. mutual consistency
3. horizontal fragmentation
4. replication
The ____ protocol is used by the DP to roll back and/or roll forward transactions with the help of the system's transaction log entries.
1. PREPARE-COMMIT-ROLLBACK
2. DO-PREPARE-COMMIT
3. COMMIT-ABORT
4. DO-UNDO-REDO
In the ____ statistical generation mode, the DDBMS automatically evaluates and updates the statistics after each access.
1. static
2. dynamic
3. manual
4. rule-based
A ____ query optimization algorithm is based on a set of user-defined rules to determine the best query access strategy.
1. statistically based
2. rule-based
3. manual
4. dynamic
____ transparency exists when the end user or programmer must specify both the fragment names and their locations.
1. Local mapping
2. Location
3. Performance
4. Transaction
A(n) ____ database stores each database fragment at a single site.
1. partially replicated
2. instance replicated
3. fully replicated
4. unreplicated
Under the ____ scenario, multiple processes run on different computers sharing a single data repository.
1. single-site processing, single-site data
2. multiple-site processing, single-site data
3. single-site processing, multiple-site data
4. multiple-site processing, multiple-site data
A distributed ____ allows a transaction to reference several different remote sites.
1. request
2. site
3. data location
4. transaction
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.
1. replicated
2. two-phase
3. remote
4. distributed
____ fragmentation allows us to break a single object into two or more segments or fragments.
1. Horizontal
2. Vertical
3. Data
4. Mixed
In ____ fragmentation a table may be divided into several horizontal subsets, each one having a subset of the attributes.
1. data
2. mixed
3. vertical
4. horizontal
Which of the following factors influences the decision to use replication?
1. database content
2. database size
3. data style
4. number of users
____ query optimization is scheduled and selected by the end user or programmer.
1. Manual
2. Static
3. Automatic
4. Dynamic
Data ____ refers to the storage of data copies at multiple sites served by a computer network.
1. replication
2. fragmentation
3. persistence
4. optimization
What feature is a DDBMS advantage?
1. reduced operating cost
2. complexity of management and control
3. increased storage requirements
4. increased training cost
____ query optimization takes place at execution time.
1. Automatic
2. Static
3. Manual
4. Dynamic
The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.
1. transaction
2. network
3. data
4. management

Distributed Databases, Chapter 14

Quiz