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