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