63.
(p. 189)
_______________ are used to model the relationships among the many entities involved in business
processes.
64.
The physical design stage of database development:
65.
(p. 190)
The _______________ stage of database development translates the conceptual models into the data
model of a DBMS.
66.
(p. 190)
A _______________ is an overall logical view of the relationships among the data elements in a
database.
67.
(p. 191)
A _______________ is an overall logical view of the relationships needed to support specific end-user
application programs that will access the database.
68.
(p. 192)
According to the textbook case, the innovation of the open-source product Hadoop is
_______________.
69.
(p. 192)
According to the textbook case, file processing in Hadoop is not halted by hardware failures because
_______________.
70.
(p. 193)
Operational databases store the detailed data needed to support the business processes and operations
of a company. They are also called _______________.
71.
The primary challenge of a distributed database is:
72.
(p. 197)
Which of the following statements concerning the replication and duplication process for updating
distributed databases is correct?
73.
(p. 197)
What type of databases are employees using when they access online data banks, whether those data
banks are free or paid for through subscriptions?
74.
(p. 199)
A central source of data that have been cleaned, transformed, and cataloged so that they can be used
for business analysis, market research, and decision support is called a _______________.
75.
A data warehouse contains data that have been processed in all the following ways except:
76.
Which of the following is true of data marts?
77.
Which of the following is true of data in a data warehouse?
78.
Which of the following is a legitimate use for data mining?
79.
According to the textbook case, on cars:
80.
All of the following contribute to problems when using a file management approach except:
81.
(p. 204)
Database management involves the use of database management software to control how databases
are _______________.
82.
(p. 204)
In mainframe and server computer systems, the database management system controls the
_______________ of the databases of computer-using organizations.
83.
All of the following are major functions of a database management system except:
84.
(p. 206)
Database development involves defining and organizing the _______________ of the data needed to
build a database.
85.
A DBMS query language is designed to:
86.
The database maintenance process is accomplished via:
87.
The basic form of a SQL query is:
88.
Boolean logic deals with three logical operators:
89.
(p. 208)
Many end users have trouble correctly phrasing database language search queries, so most end-user
DBMS packages now offer _______________ methods.
90.
(p. 178)
All of the fields used to describe the attributes of an entity are grouped to form a
_______________.
91.
_______________ contain both a variable number of fields and variable field lengths.
92.
_______________ contain both a fixed number of fields and fixed field lengths.
93.
A group of related records is a data file, or a _______________.
94.
A _______________ is an integrated collection of logically related data elements.
95.
(p. 182)
Databases contain data elements that describe both entities and the _______________ among
entities.
96.
(p. 184)
In the relational database model, all data elements within the database are viewed as being stored in
the form of simple, two-dimensional tables, sometimes referred to as _______________.
97.
(p. 184)
The tables in a relational database are flat files, which have rows and columns. Each row presents a
single _______________ in the file.
98.
(p. 184)
The tables in a relational database are flat files, which have rows and columns. Each column
represents a _______________.
99.
(p. 185)
The _______________ operation is used to create a subset of the columns contained in the temporary
tables created by the select and join operations.
100.
(p. 185)
An _______________ consists of data values describing the attributes of an entity, plus the operations
that can be performed upon the data.
101.
(p. 187)
A weakness in the hierarchical model is that it cannot handle _______________ data
relationships.
102.
A weakness in the network model is that it cannot handle _______________ for information.
103.
(p. 188)
A database of data definitions and specifications is called a metadata repository, or a
_______________.
104.
(p. 189)
Database administrators and designers work with corporate and end user management to develop an
_______________ model that defines the basic business process of the enterprise.
105.
(p. 189)
_______________ relationship diagrams are used to model the relationships among the many entities
involved in business processes.
106.
(p. 190)
A _______________ is an overall logical view of the relationships among the data elements in a
database.
107.
(p. 191)
_______________ database design takes a physical view of the data that describes how data are to be
physically stored and accessed on the storage devices of a computer system.
108.
Data models represent _______________ views of the data and relationships of the database.
109.
(p. 189)
Entity Relationship Diagrams are _______________ of the various files and their relationships within
a database system.
110.
(p. 197)
A website stores hyperlinked pages of multimedia (text, graphics, photographs, video, and audio) in a
_______________ database.
111.
(p. 197)
The duplication process basically identifies one database as a _______________ and then duplicates
that database at a prescribed time so that each distributed location has the same data.
112.
(p. 199)
Data warehouses may be subdivided into _______________, which hold subsets of data from
the warehouse that focus on specific aspects of a company, such as a department or a business
process.
113.
(p. 199)
_______________, data that define the data in the data warehouse, are stored in a metadata repository
and cataloged by a metadata directory.
114.
(p. 200)
In _______________, the data in a data warehouse are analyzed to reveal hidden patterns and trends
in historical business activity.
115.
(p. 203)
To solve the problems encountered with the file processing approach, the _______________
management approach was conceived. It is the foundation of modern methods of managing
organizational data.
116.
(p. 208)
Database _______________ involves using transaction processing systems and other tools to add,
delete, update, and correct the data in a database.
117.
(p. 206-
SQL is an acronym for _______________. It is an international standard query language found in
many DBMS packages.
118.
The basic form of a SQL query is SELECT…FROM… _______________.
119.
Boolean logic consists of three logical operators: AND, OR, and _______________.
NOT
ch5 Summary
Category # of Questions
AACSB: Technology 119
Blooms: Knowledge 119
Difficulty: Easy 13
Difficulty: Hard 39
Difficulty: Medium 67
Learning Objective: 1 11
Learning Objective: 2 6
Learning Objective: 3 16
Learning Objective: 4 86
OBrien – Chapter 05 119