b
,Modern Database Management, 13e (Hoffer)
b b b b
Chapter 1 The Database Environment and Development Process
b b b b b b b
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
b b b b b b b b b b b b
more than:
b b
A) 1 terabyte of data.
b b b
B) 3 gigabytes of data.
b b b
C) at least 100 petabytes of data.
b b b b b
D) more than 7 billion exabytes of data.
b b b b b b
Answer: D
b b
LO: 1.1:Define keyterms.
b b b b
Difficulty: Easy
b b
Classification: Concept
b b
AACSB: Information Technology b b
2) Database management involves all of the following EXCEPT:
b b b b b b b
A) collecting data. b
B) organizing data. b
C) design web pages. b b
D) managing data. b
Answer: C b
LO: 1.1:Define keyterms.
b b b b
Difficulty: Easy
b b
Classification: Concept
b b
AACSB: Information Technology b b
3) A database is an organized collection of
b b b b b b related data. b
A) logically
B) physically
C) loosely
D) badly
Answer: A
b b
LO: 1.1:Define keyterms.
b b b b
Difficulty: Easy
b b
Classification: Concept
b b
AACSB: Information Technology b b
4) Legacy systems often contain data of b b b b b quality and are generally hosted on
b b b b b .
A) poor; personal computers
b b
B) excellent; mainframes b
C) poor; mainframes b
D) excellent; workgroup computers b b
Answer: C
b b
LO: 3.1: Define key terms.
b b b b
,5) Program-data dependence is caused by: b b b b
A) file descriptions being stored in each database application.
b b b b b b b
B) data descriptions being stored on a server.
b b b b b b
C) data descriptions being written into programming code.
b b b b b b
D) datacohabiting withprograms.
b b b
Answer: A
b b
LO: 1.2: Name several limitations ofconventional file processing systems.
b b b b b b b b b
Difficulty: Moderate
b b
Classification: Concept b
AACSB: Information Technology b b
6) Because applications are often developed independently in file processing systems:
b b b b b b b b b
A) the data is always non-redundant.
b b b b
B) unplanned duplicate data files are the rule rather than the exception.
b b b b b b b b b b
C) data can always be shared with others.
b b b b b b
D) there is a large volume of file I/O.
b b b b b b b
Answer: B
b b
LO: 1.2: Name several limitations ofconventional file processing systems.
b b b b b b b b b
Difficulty: Moderate
b b
Classification: Concept b
AACSB: Information Technology b b
7) Relational databases establish the relationships between entities bymeans ofcommon fields
b b b b b b b b b b b
included in a file called a(n):
b b b b b b
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
b b
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file
b b b b b b b b b b b b b b
processing.
b
Difficulty: Moderate b
Classification: Concept
b b
AACSB: Information Technology b b
8) A(n) is often developed by identifying a form or report that a user needs on a b b b b b b b b b b b b b b
regular basis.
b b
A) enterprise view b
B) reporting document b
C) user view b
D) usersnapshot b
Answer: C
b b
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file
b b b b b b b b b b b b b b
processing.
b
, 9) A graphical system used to capture the nature and relationships among data is called a(n):
b b b b b b b b b b b b b b
A) XML data model.
b b
B) hypertext graphic. b
C) relational database. b
D) data model.
b
Answer: D b
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file
b b b b b b b b b b b b b b
processing.
b
Difficulty: Moderate b
Classification: Concept
b b
AACSB: Information Technology
b b
10) Data that describe the properties of other data are:
b b b b b b b b
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
b b
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file
b b b b b b b b b b b b b b
processing.
b
Difficulty: Moderate b
Classification: Concept
b b
AACSB: Information Technology
b b
11) Metatdata typically describes all of the following EXCEPT:
b b b b b b b
A) data definitions.
b
B) length.
C) allowable values. b
D) location on disk. b b
Answer: D b
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file
b b b b b b b b b b b b b b
processing.
b
Difficulty: Moderate b
Classification: Concept
b b
AACSB: Information Technology
b b
4
Copyright © 2019 Pearson Education, Inc.
b b b b b