Quiz
Chapter 12 (MC)
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (30)
11.____ is a disadvantage of a DDBMS.
- Aa.Data is located near the “greatest demand” site
- Bb.Growth facilitation
- Cc.Danger of a single-point failure
- Dd.Lack of standards
22.____ is a disadvantage of a DDBMS.
- Aa.Processor independence
- Bb.The graphical user interface
- Cc.Security
- Dd.Data access that is too rapid
33.____ are an advantage of a DDBMS
- Aa.Reduced operating cost
- Bb.Simplicity of management and control
- Cc.Decreased storage requirements
- Dd.Decreased training costs
44.A distributed database is composed of several parts known as database ____.
- Aa.sections
- Bb.fragments
- Cc.partitions
- Dd.parts
55.The ____ processor is the software component found in each computer that requests data. It receive sand processes the application's data requests.
- Aa.database
- Bb.transaction
- Cc.data
- Dd.network
66.The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.
- Aa.transaction
- Bb.network
- Cc.data
- Dd.management
77.Under the ____ scenario, multiple processes run on different computers sharing a single data repository.
- Aa.single-site processing, single-site data
- Bb.multiple-site processing, single-site data
- Cc.single-site processing, multiple-site data
- Dd.multiple-site processing, multiple-site data
88.The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
- Aa.multiple-site processing, single-site data
- Bb.single-site processing, multiple-site data
- Cc.single-site processing, single-site data
- Dd.multiple-site processing, multiple-site data
99.____ distributed database systems integrate only one type of centralized DBMS over a network.
- Aa.Homogeneous
- Bb.Heterogeneous
- Cc.Fully heterogeneous
- Dd.Combination
1010.____ distributed database systems integrate different types of centralized DBMSs over a network.
- Aa.Homogeneous
- Bb.Heterogeneous
- Cc.Fully homogeneous
- Dd.Combination
1111.A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.
- Aa.fully heterogeneous
- Bb.fully homogeneous
- Cc.homogeneous
- Dd.heterogeneous
1212.____ transparency allows a distributed database to be treated as a single logical database.
- Aa.Distribution
- Bb.Transaction
- Cc.Failure
- Dd.Performance
1313.____ transparency allows a transaction to update data at several network sites.
- Aa.Transaction
- Bb.Distribution
- Cc.Failure
- Dd.Performance
1414.____ transparency ensures that the system will continue to operate in the event of a node failure.
- Aa.Transaction
- Bb.Distribution
- Cc.Failure
- Dd.Performance
1515.____ transparency allows the system to perform as if it were a centralized database management system.
- Aa.Heterogeneity
- Bb.Distribution
- Cc.Performance
- Dd.Failure
1616.____ transparency allows the integration of several different local DBMSs under a common, or global,schema.
- Aa.Transaction
- Bb.Performance
- Cc.Distribution
- Dd.Heterogeneity
1717.____ is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.
- Aa.Performance
- Bb.Fragmentation
- Cc.Location
- Dd.Local mapping
1818.____ 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.
- Aa.Transaction
- Bb.Location
- Cc.Local mapping
- Dd.Fragmentation
1919.____ transparency exists when the end user or programmer must specify both the fragment names and their locations
- Aa.Local mapping
- Bb.Location
- Cc.Performance
- Dd.Transaction
2020.A ____ contains the description of the entire database as seen by the database administrator.
- Aa.distributed global dictionary
- Bb.distributed data dictionary
- Cc.distributed global schema
- Dd.distributed data schema
2121.A distributed ____ allows a transaction to reference several different remote database processing sites.
- Aa.request
- Bb.site
- Cc.data location
- Dd.transaction
2222.The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.
- Aa.distributed
- Bb.transaction
- Cc.fragmented
- Dd.transparent
2323.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.
- Aa.DO-UNDO-REDO protocol
- Bb.two-phase commit protocol (2PC
- Cc.coordinator protocol
- Dd.write-ahead protocol
2424.The objective of ____ optimization is to minimize the total cost associated with the execution of a request.
- Aa.data
- Bb.remote
- Cc.transaction
- Dd.query
2525.____ 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.
- Aa.Data distribution
- Bb.Replica transparency
- Cc.Network latency
- Dd.Network partitioning
2626.____ fragmentation allows you to break a single object into two or more segments or fragments.
- Aa.Horizontal
- Bb.Vertical
- Cc.Data
- Dd.Mixed
2727.____ fragmentation refers to the division of a relation into subsets of tuples.
- Aa.Vertical
- Bb.Horizontal
- Cc.Data
- Dd.Mixed
2828.____ fragmentation refers to the division of a relation into attribute subsets.
- Aa.Data
- Bb.Horizontal
- Cc.Vertical
- Dd.Mixed
2929.The ____ rule requires that all copies of data fragments be identical.
- Aa.shared fragment
- Bb.mutual consistency
- Cc.horizontal fragmentation
- Dd.replication
3030.A(n)____ database stores each database fragment at a single site.
- Aa.partially replicated
- Bb.unreplicated
- Cc.fully replicated
- Dd.partitioned
Information
- Description
- asdf Quiz on Chapter 12 (MC), created by . . on 07/12/2016.
- Author
- . .
- Language
- English
- Views
- 61
- History
- Created on 7 Dec 2016 · updated on 10 Dec 2016
- Tags
- Rating
- No ratings yet Rate this quiz