Chapter 05
E-commerce presents a major opportunity for the effective use of
data mining. TRUE
Data marts are usually larger than data warehouses. FALSE
One of the goals of a DBMS is to increase data redundancy thereby
making it less vulnerable to hackers. FALSE
A primary key is a field or set of fields that uniquely identifies
a record. TRUE
ER diagrams can serve as reference documents once a database is in
use. TRUE
A database is a collection of integrated and related files. TRUE
The use of competitive intelligence is illegal and unethical. FALSE
The smallest piece of data used by computers is called a ____.
a. |
byte |
b. |
character |
c. |
bit |
d. |
megabyte |
A collection of related data fields is called a ____.
a. |
byte |
b. |
record |
c. |
character |
d. |
bit |
A(n) ____ is a generalized class of people, places, or things
for which data is collected, stored, and maintained.
a. |
record |
b. |
entity |
c. |
attribute |
d. |
file |
In a relational database, the customer record contains information
regarding the customer's last name. The last name is a(n)
____.
a. |
attribute |
b. |
entity |
c. |
key |
d. |
object |
Which attribute would make the best primary key?
a. |
Social
security number |
b. |
Last name |
c. |
First name |
d. |
Age |
A more efficient and effective means of organizing data was
developed with ____.
a. |
the
database approach to data management |
b. |
the traditional approach to data
management |
c. |
the network approach to data management |
d. |
the hierarchical approach to data management |
The database approach to data management requires ____.
a. |
at least one flat file |
b. |
data redundancy |
c. |
a
DBMS |
d. |
program-data dependence |
Which of the following is NOT an advantage of the database
approach to data management?
a. |
Reduced data redundancy |
b. |
Data
and program dependence |
c. |
Framework for program development |
d. |
Better overall protection of the data |
Roger Rotune created an ER diagram that
encompassed the requirements of his organization. This is an example of ____.
a. |
data warehousing |
b. |
data systems modeling |
c. |
organizational data modeling |
d. |
enterprise
data modeling |
A ____ is a diagram of entities and their relationships.
a. |
data
model |
b. |
data flow diagram |
c. |
hierarchical model |
d. |
file diagram |
A data model that uses basic graphical symbols to show the
relationships between data is a(n) ____.
a. |
planned redundancy model |
b. |
entity-relationship
diagram |
c. |
hierarchical data model |
d. |
network data model |
The ____ data model follows a treelike structure.
a. |
distributed |
b. |
hierarchical |
c. |
network |
d. |
relational |
The most popular database model currently in use is the ____.
a. |
relational
model |
b. |
hierarchical model |
c. |
network model |
d. |
object model |
As long as tables in a database ____, they can be linked to
provide useful information.
a. |
share
at least one common element |
b. |
share two or more common elements |
c. |
are projected |
d. |
have been normalized |
The purpose of ____ is to develop data that is accurate and
complete.
a. |
linking |
b. |
joining |
c. |
data
cleanup |
d. |
data modeling |
A ____ provides a detailed description of all data used in the
database.
a. |
network model |
b. |
data
dictionary |
c. |
data model |
d. |
schema |
One of the first steps in installing and using a database involves
____.
a. |
data cleaning |
b. |
determining
the schema |
c. |
training users |
d. |
writing SQL for data manipulation |
A ____ allows the database's creator to describe the logical
access paths and logical records in a database.
a. |
DDL |
b. |
DML |
c. |
data model |
d. |
data dictionary |
To speed up processing, Pill's Pottery Company sends a copy of
important data to each of its five warehouses. At the end of the day, any
changes are sent back to the main database. Pill's is using ____.
a. |
ODBC |
b. |
OLAP |
c. |
replicated
databases |
d. |
data warehouses |
Cranberry Farms, Inc. in
a. |
replicated database |
b. |
distributed
database |
c. |
data file approach |
d. |
flat file approach |