CHAPTER 12: DISTRIBUTED DATABASE MANAGEMENT SYSTEMS
1. Distributed data access was needed to support geographically dispersed business units.
a. True
b. False
a. True
b. False
data over interconnected computer systems.
a. True
b. False
a. True
b. False
5. One of the advantages of a distributed database management system (DDBMS) is that the data is located near
the site with the least demand.
a. True
b. False
6. One of the advantages of a distributed database management system (DDBMS) is growth facilitation.
a. True
b. False
7. One of the advantages of a distributed database management system (DDBMS) is improved communication.
a. True
b. False
8. One of the advantages of a distributed database management system (DDBMS) is security.
a. True
b. False
Chapter 12: Distributed Database Management Systems
9. Current distributed database management system (DDBMS) are subject to some problems, such as the
complexity of management and control.
a. True
b. False
10. Distributed processing shares a database’s logical processing among two or more physically independent sites
that are connected through a network.
a. True
b. False
11. Distributed processing does not require a distributed database, and a distributed database does not require
distributed processing.
a. True
b. False
all data storage sites.
a. True
b. False
13. Both distributed processing and distributed databases require a network of interconnected components.
a. True
b. False
14. A database management system (DBMS) must have validation, transformation, and mapping functions, as well
as other functions, in order to be classified as distributed.
a. True
b. False
15. 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.
a. True
b. False
Chapter 12: Distributed Database Management Systems
16. The transaction processor (TP) is the software component found in each computer that requests data.
a. True
b. False
17. A distributed database management system (DDBMS) must be communications-media-dependent.
a. True
b. False
18. A transaction processor (TP) is the software component residing on each computer that stores and retrieves
data located at the site.
a. True
b. False
19. In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user’s
side of the system.
a. True
b. False
20. Performance transparency ensures that the system finds the most cost-effective path to access remote data.
a. True
b. False
21. Distribution transparency is supported by a distributed data dictionary.
a. True
b. False
22. The level of transparency supported by the distributed database management system remains the same for all
systems.
a. True
b. False
Chapter 12: Distributed Database Management Systems
23. Distributed database systems do not require complex mechanisms to manage transactions and ensure the
database’s consistency and integrity.
a. True
b. False
24. A remote transaction, composed of several requests, may access data at multiple sites.
a. True
b. False
25. 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
26. 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.
27. 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
28. 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
29. A distributed database is composed of several parts known as database .
a. sections b. fragments
c. partitions d. parts
30. 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.
Chapter 12: Distributed Database Management Systems
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
32. 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
33. 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
34. 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
35. 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
36. 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.
Chapter 12: Distributed Database Management Systems
37. _____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS
over a network.
a. Homogeneous b. Heterogeneous
c. Fully heterogeneous d. Combination
38. distributed database systems integrate different types of centralized database management systems
(DBMS) over a network.
a. Homogeneous b. Heterogeneous
c. Fully homogeneous d. Combination
39. 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
40. transparency allows a physically dispersed database to be managed as though it were centralized.
a. Distribution b. Transaction
c. Failure d. Performance
41. transparency allows data to be updated simultaneously at several network sites.
a. Transaction b. Distribution
c. Failure d. Performance
42. 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
43. transparency allows the system to operate as if it were a centralized database management system.
a. Heterogeneity b. Distribution
c. Performance d. Failure
Chapter 12: Distributed Database Management Systems
44. 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
45. 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
46. 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
47. 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
48. 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
49. A distributed can reference several different local or remote data processing sites.
a. request b. site
c. data location d. transaction
50. 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
Chapter 12: Distributed Database Management Systems
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
52. 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
53. 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
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
55. fragmentation allows a user to break a single object into two or more segments, or fragments.
a. Horizontal b. Vertical
c. Data d. Request
56. fragmentation refers to the division of a relation into subsets of tuples.
a. Vertical b. Horizontal
c. Data d. Mixed
57. fragmentation refers to the division of a relation into attribute subsets.
a. Data b. Horizontal
c. Vertical d. Mixed
58. The rule requires that all copies of data fragments be identical.
a. shared fragment b. mutual consistency
c. horizontal fragmentation d. replication
Chapter 12: Distributed Database Management Systems
59. A(n) database stores each database fragment at a single site.
a. partially replicated b. unreplicated
c. fully replicated d. partitioned
60. One of the advantages of a distributed database management system (DDBMS) is operating cost.
61. A user-friendly is one advantage of a distributed database management system (DDBMS) .
62. One of the advantages of a distributed database management system (DDBMS) is less danger of a single–
failure.
63. One of the advantages of a distributed database management system (DDBMS) is processor .
64. In a basic distributed processing environment, the distributed processing system shares the database chores
among three sites connected through a .
65. management ensures that data move from one consistent state to another.
66. In a distributed database management system (DDBMS), occurs to determine the data location of local
and remote fragments.
67. In a distributed database management system (DDBMS), query is used to find the best access strategy.
68. In a distributed database management system (DDBMS), control is used to manage simultaneous data
access and ensure data consistency across database fragments.
69. A transaction processor is also known as the processor.
70. The distributed database system must be of the computer hardware system.
Chapter 12: Distributed Database Management Systems
71. The scenario is typical of most mainframe and midrange UNIX/LINUX server database management
systems (DBMS).
72. Typically, the scenario requires a network file server running conventional applications that are accessed
through a network.
73. If a distributed database management system (DDBMS) exhibits transparency, a 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.
74. The fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is
located.
75. 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).
76. The protocol is used by a DP to roll transactions back and forward with the help of the system’s
transaction log entries.
77. The forces the log entry to be written to permanent storage before the actual operation takes place.
Chapter 12: Distributed Database Management Systems
78. A fully distributed database management system must perform all of the functions of a centralized database
management system (DBMS). What are these functions?
79. Explain the difference between homogeneous and heterogeneous distributed database management systems
(DDBMS).
80. Describe performance transparency and heterogeneity transparency.
81. 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)?
82. Explain the three types of operations defined by the DO-UNDO-REDO protocol.