61.
(p. 189)
Database administrators and database design analysts work with end users and systems
analysts to do all of the following except:
62.
(p. 189)
_______________ are used to model the relationships among the many entities involved in
business processes.
63.
(p. 190)
The physical design stage of database development:
64.
(p. 190)
The _______________ stage of database development translates the conceptual models into
the data model of a DBMS.
65.
(p. 190)
A _______________ is an overall logical view of the relationships among the data elements in
a database.
66.
(p. 191)
A _______________ is an overall logical view of the relationships needed to support specific
end-user application programs that will access the database.
67.
(p. 192)
According to the textbook case, the innovation of the open-source product Hadoop is
_______________.
68.
(p. 192)
According to the textbook case, file processing in Hadoop is not halted by hardware failures
because _______________.
69.
(p. 193)
Operational databases store the detailed data needed to support the business processes and
operations of a company. They are also called _______________.
70.
(p. 197)
The primary challenge of a distributed database is:
71.
(p. 197)
Which of the following statements concerning the replication and duplication process for
updating distributed databases is correct?
72.
(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?
73.
(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
_______________.
74.
(p. 199)
A data warehouse contains data that have been processed in all the following ways except:
75.
(p. 199)
Which of the following is true of data marts?
76.
(p. 199–
200)
Which of the following is true of data in a data warehouse?
77.
(p. 201)
Which of the following is a legitimate use for data mining?
78.
(p. 203)
All of the following contribute to problems when using a file management approach except:
79.
(p. 204)
Database management involves the use of database management software to control how
databases are _______________.
80.
(p. 204)
In mainframe and server computer systems, the database management system controls the
_______________ of the databases of computer-using organizations.
81.
(p. 206)
All of the following are major functions of a database management system except:
82.
(p. 206)
Database development involves defining and organizing the _______________ of the data
needed to build a database.
83.
(p. 206)
A DBMS query language is designed to:
84.
(p. 206)
The database maintenance process is accomplished via:
85.
(p. 207)
The basic form of a SQL query is:
86.
(p. 207)
Boolean logic deals with three logical operators:
87.
(p. 208)
Many end users have trouble correctly phrasing database language search queries, so most
end-user DBMS packages now offer _______________ methods.
88.
(p. 178)
All of the fields used to describe the attributes of an entity are grouped to form a
_______________.
89.
(p. 181)
_______________ contain both a variable number of fields and variable field lengths.
90.
(p. 181)
_______________ contain both a fixed number of fields and fixed field lengths.
91.
(p. 181)
A group of related records is a data file, or a _______________.
92.
(p. 181)
A _______________ is an integrated collection of logically related data elements.
93.
(p. 182)
Databases contain data elements that describe both entities and the _______________
among entities.
94.
(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
_______________.
95.
(p. 184)
The tables in a relational database are flat files, which have rows and columns. Each row
presents a single _______________ in the file.
96.
(p. 184)
The tables in a relational database are flat files, which have rows and columns. Each column
represents a _______________.
97.
(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.
98.
(p. 185)
An _______________ consists of data values describing the attributes of an entity, plus the
operations that can be performed upon the data.
99.
(p. 187)
A weakness in the hierarchical model is that it cannot handle _______________ data
relationships.
100.
(p. 187)
A weakness in the network model is that it cannot handle _______________ for information.
101.
(p. 188)
A database of data definitions and specifications is called a metadata repository, or a
_______________.
102.
(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.
103.
(p. 189)
_______________ relationship diagrams are used to model the relationships among the many
entities involved in business processes.
104.
(p. 190)
A _______________ is an overall logical view of the relationships among the data elements in
a database.
105.
(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.
106.
(p. 190)
Data models represent _______________ views of the data and relationships of the
database.
Marakas – Chapter 05 #106
107.
(p. 189)
Entity Relationship Diagrams are _______________ of the various files and their relationships
within a database system.
108.
(p. 197)
A website stores hyperlinked pages of multimedia (text, graphics, photographs, video, and
audio) in a _______________ database.
109.
(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.
110.
(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.
111.
(p. 199)
_______________, data that define the data in the data warehouse, are stored in a metadata
repository and cataloged by a metadata directory.
112.
(p. 200)
In _______________, the data in a data warehouse are analyzed to reveal hidden patterns
and trends in historical business activity.
113.
(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.
114.
(p. 208)
Database _______________ involves using transaction processing systems and other tools to
add, delete, update, and correct the data in a database.
115.
(p. 206–
207)
SQL is an acronym for _______________. It is an international standard query language
found in many DBMS packages.
116.
(p. 207)
The basic form of a SQL query is SELECT…FROM… _______________.
117.
(p. 207)
Boolean logic consists of three logical operators: AND, OR, and _______________.
5 Summary
Category
# of Qu
estions
AACSB: Technology
117
Blooms: Remember
117
Difficulty: 1 Easy
12
Difficulty: 2 Medium
66
Difficulty: 3 Hard
39
Learning Objective: 05–
01 Explain the business value of implementing data resource management processes and technologies in an organization.
10
Learning Objective: 05–
02 Outline the advantages of a database management approach to managing the data resources of a business; compared wit
h a file processing approach.
6
Learning Objective: 05–
03 Explain how database management software helps business professionals and supports the operations and management
of a business.
16
Learning Objective: 05–
04 Provide examples to illustrate each of the following concepts: a. Major types of databases.; b. Data warehouses and data m
ining.; c. Logical data elements.; d. Fundamental database structures.; e. Database development.
85
Marakas – Chapter 05
117