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