Chapter 9: Database Management Approaches
1. A distributed database is a single logical database that is physically divided among computers at several sites
on a network.
a.
True
b.
False
True
1
276
2. Accessing data using messages over a network is substantially slower than accessing data on a disk.
a.
True
b.
False
True
1
276
3. Seek delay refers to the fixed amount of time that is required for every message.
a.
True
b.
False
4. In a DDBMS, the site where the user is located is called the remote site.
a.
True
b.
False
5. A characteristic of a DDBMS that states that users do not need to be aware of the location of the data in a
database is known as replication transparency.
a.
True
b.
False
6. If users are unaware of fragmentation, the DDBMS has fragmentation transparency.
a.
True
b.
False
True
1
279
7. A local deadlock involves one transaction that requires a record held by a second transaction at one site, while
Chapter 9: Database Management Approaches
the second transaction requires a record held by the first transaction at a different site.
a.
True
b.
False
8. A global deadlock occurs at a single site in a distributed database.
a.
True
b.
False
9. A file server stores the files required by the users on a network.
a.
True
b.
False
True
1
283
10. On a client/server network, the server is a computer that provides data to the clients.
a.
True
b.
False
True
1
284
11. The server is also known as a front-end processor or front-end machine.
a.
True
b.
False
12. If the client only performs the presentation functions (and not the business functions), then the client is known as a fat
client.
a.
True
b.
False
13. Each Web page is assigned an Internet address called a Uniform Resource Locator (URL).
a.
True
Chapter 9: Database Management Approaches
b.
False
True
1
287
14. An XML document should begin with an XML declaration.
a.
True
b.
False
True
1
292
15. Access to a data warehouse is accomplished through the use of OLAP software.
a.
True
b.
False
True
1
295
16. In order to view and analyze higher levels of aggregate data, you must drill down the data.
a.
True
b.
False
17. When relational databases store complex objects, these special data types are known as VLOBs.
a.
True
b.
False
18. The term class refers to the general structure of an object.
a.
True
b.
False
True
1
301
19. The actions defined for a class are known as methods.
a.
True
b.
False
True
1
20. One approach you can use to model all the various aspects of software development for object-oriented systems is
known as UML.
a.
True
b.
False
True
1
303
21. When computers at one site need to be connected with computers at another site, the connection must be within a
____.
a.
room
b.
building
c.
network
d.
combination
1
275
22. Computers in a network communicate through ____.
a.
tokens
b.
messages
c.
notes
d.
letters
b
1
276
23. The formula for message transmission time is: communication time = access delay + (data volume / X), where X
represents ____.
a.
transmission rate
b.
length of transmission
c.
lag time
d.
seek time
1
276
24. A DDBMS that has at least two sites at which the local DBMS are different is known as a ____.
a.
homogeneous DDBMS
b.
heterogeneous DDBMS
c.
holistic DDBMS
d.
DDBMS
b
301
25. When users are unaware of the steps taken by the DDBMS to update the various copies of data, this characteristic of
the DDBMS is called ____.
a.
location transparency
b.
fragmentation transparency
c.
replication transparency
d.
location site license
1
277
26. Which of the following is an advantage of distributed databases?
a.
Local control of data
b.
Easier updates of replicated data
c.
More complex query processing
d.
More complex treatment of concurrent updates
1
279
27. When a centralized database becomes unavailable for any reason, no users can continue processing. In contrast, if a
local database in a distributed database becomes unavailable, only users who need that data are affected. Because of this,
distributed databases have a(n) ____ advantage over a centralized database.
a.
local control of data
b.
increasing database capacity
c.
system availability
d.
added efficiency
1
279
28. It is possible for local DBMSs to commit updates at some sites and undo updates at other sites. This inconsistency can
be prevented by using a ____.
a.
two-step rollback
b.
two-phase commit
c.
two-phase rollback
d.
two-phase transaction
b
1
282
29. The site that initiates the update in a two-phase commit is known as the ____.
a.
director
b.
initiator
1
277
Chapter 9: Database Management Approaches
c.
coordinator
d.
leader
1
30. ____ implies that the performance of functions such as adding sites, changing versions of DBMSs, creating backups,
and modifying hardware should not require planned shutdowns of the entire distributed database.
a.
Continuous operation
b.
Local autonomy
c.
Location transparency
d.
Fragmentation transparency
283
31. ____ implies that users should not need to be concerned with the location of any specific data in the database.
a.
Fragmentation transparency
b.
Replication transparency
c.
Location transparency
d.
Distributed query processing
1
283
32. ____ implies that no site should depend on another site to perform its database functions.
a.
No reliance on a central site
b.
Local autonomy
c.
Continuous operation
d.
Fragmentation transparency
1
33. ____ is the ability of a computer system to continue to function well as utilization of the system increases.
a.
Data fragmentation
b.
Data mining
c.
Scalability
d.
Polymorphism
1
34. Because the clients and the server perform different functions and can run two different operating systems, there is an
arrangement of client/server architecture known as ____.
Chapter 9: Database Management Approaches
a.
single-tier architecture
b.
two-tier architecture
c.
three-tier architecture
d.
four-tier architecture
b
1
285
35. If the client, in a client/server system, performs the business functions (calculations, etc.), then this client is known as
a(n) ____.
a.
thin client
b.
fat client
c.
overweight client
d.
external client
b
1
285
36. Each digital document on the Web is called a ____.
a.
Web server
b.
Web browser
c.
client
d.
Web page
d
1
287
37. ____ is the data communication method used by Web clients and Web servers to exchange data on the Internet.
a.
UML
b.
HTTP
c.
URL
d.
IIS
b
1
287
38. ____ is a metalanguage derived from a restricted subset of SGML, and designed for the exchange of data on the Web.
a.
UML
b.
URL
c.
XML
d.
HTTP
1
290
Chapter 9: Database Management Approaches
39. When users interact with an RDBMS, they use transactions. These types of systems are called ____ systems.
a.
OLTP
b.
ODBMS
c.
OLAP
d.
ODBC
1
294
40. When the data is organized by entity rather than by the application that uses the data, it is called ____.
a.
table-oriented
b.
row-oriented
c.
column-oriented
d.
subject-oriented
d
1
294
41. With respect to the definition of data warehouse, ____ means that data is stored in one place, even though it originates
from everywhere in the organization and from a variety of external sources.
a.
time-variant
b.
nonvolatile
c.
subject-oriented
d.
integrated
d
1
295
42. With respect to the definition of data warehouse, ____ means that the data is read-only.
a.
time-variant
b.
integrated
c.
nonvolatile
d.
subject-oriented
1
295
43. With respect to the definition of data warehouse, ____ means that data in a data warehouse represents snapshots of
data at various points in time in the past.
a.
nonvolatile
b.
time-variant
c.
subject-oriented
d.
integrated
1
Chapter 9: Database Management Approaches
44. A ____ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management’s
decision-making process.
a.
data warehouse
b.
thin client
c.
back-end processor
d.
fat client
1
294
45. Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields
associated with the primary key value.
a.
primary table
b.
fact table
c.
dimension table
d.
star table
1
295
46. A(n) ____ consists of rows that contain consolidated and summarized data.
a.
class
b.
data model
c.
fact table
d.
object
1
295
47. Uncovering new knowledge, patterns, trends, and rules from the data stored in a data warehouse is known as ____.
a.
fragmentation transparency
b.
replication transparency
c.
polymorphism
d.
data mining
d
1
298
48. In ____ systems, data and actions are encapsulated.
a.
relational
b.
object-oriented
c.
network
d.
parallel
295
Chapter 9: Database Management Approaches
b
1
299
49. In ____ systems, you create actions as part of data manipulation rather than as part of data definition.
a.
object-oriented
b.
relational
c.
parallel
d.
simple
b
1
299
50. ____ refers to the association of an operation to actual program code.
a.
Attaching
b.
Matching
c.
Linking
d.
Binding
d
1
306
51. A(n) _________________________ is a DBMS capable of supporting and manipulating distributed
databases.
1
276
52. A(n) ____________________ DDBMS is a database that has the same local DBMS at each site.
1
277
53. ____________________ link one Web page to another or link to another location in the same Web page.
1
288
54. Web pages that display the same content for all Web clients are called ____________________ Web pages.
1
288
Chapter 9: Database Management Approaches
55. E-commerce between organizations is called ____________________.
56. ____________________ implies that you define an object to contain both the data and its associated actions.
57. A(n) ______________________________ is one in which data and the actions that operate on the data are
encapsulated into objects.
58. A(n) ____________________ is the set of values that are permitted for an attribute.
59. Methods are defined during the ___________________ process.
60. To execute the steps in a method, the user sends a(n) ____________________ to the object.
61. With respect to UML, the type of diagram most relevant to database design is the ____________________.
62. On a class diagram, the lines joining the classes represent the relationships and are called ____________________.
63. On a class diagram, a(n) ____________________ symbol precedes each attribute.
64. The ____________________ symbol in a class diagram indicates whether other classes can view or update
the value in the attribute.
65. With ____________________ visibility, any other class can view or update the value of an attribute.
66. With ____________________ visibility, only the class itself or public or protected subclasses of the class
can view or update the value in the attribute.
67. With ____________________ visibility, only the class itself can view or update the value in the attribute.
68. ____________________ indicates the number of objects that can be related to an individual object at the
other end of the relationship.
69. ____________________ are restrictions placed on the data that can be stored in the database.
70. If one class is a subclass of a second class, the second class is called a(n) ____________________ of the
first class.
Chapter 9: Database Management Approaches
71. What are the advantages of distributed databases?
72. What are the advantages of a client/server system?
73. Explain the difference between a Web page, a Web server, and a Web client.
74. Discuss the differences between how client-side extensions and server-side extensions are created and executed,
including the kinds of languages used to create them.
75. What is the purpose of the following UML diagrams: class, use case, sequence, and activity?