Test Bank for Modern Database Management 14th Edition (Pearson, 2025) Jeffrey A. Hoffer, Heikki Topi, Venkataraman Ramesh and Hillol Bala, Isbn no; 9780135346853, all 14 Chapters Covered

Modern Database Management, 14e (Hoffer)
@x @x @x @x

,Chapter 1 The Database Environment and Development Process
@x @ x @x @x @x @x @x




1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises
@x @x @x @x @x @x @x @x @x @x @x @x


stored more than: @x @x


A) 1 terabyte of data.
@x @x @x


B) 3 gigabytes of data.
@x @x @x


C) at least 100 petabytes of data.
@x @x @x @x @x


D) more than 7 billion exabytes of da
@x @x @x @x @x @x


ta. Answer: D
@x @x


LO: 1.1: Define key terms.
@ x @x @x @x @


xDifficulty: Easy Classificati @x @x


on: Concept
@ x


AACSB: Information Technology
@ x @x




2) Database management involves all of the following EXCEPT:
@x @x @x @x @x @x @x


A) collecting data. @x


B) organizing data. @x


C) design web pages. @x @x


D) managing data @x


.
Answer: C @x


LO: 1.1: Define key terms.
@ x @x @x @x @


Difficulty: Easy Classificati
x @x @x


on: Concept
@ x


AACSB: Information Technology
@ x @x




3) A database is an organized collection of
@x @x @x @x @x @x related data. @x


A) logically
B) physically
C) loosely
D) badly @x


Answer: @x


A
LO: 1.1: Define key terms.
@ x @x @x @x @


Difficulty: Easy Classificati
x @x @x


on: Concept
@ x


AACSB: Information Technology
@ x @x




4) Legacy systems often contain data of
@x @x @x @x @x quality and are generally hosted on
@x @x @x @x @x .
A) poor; personal computers
@x @x


B) excellent; mainframes @x


C) poor; mainframes @x


D) excellent; workgroup computer @x @x


s Answer: C
@x @x


LO: 3.1: Define key terms.
@x @x @x @x

,5) Program-data dependence is caused by: @x @x @x @x


A) file descriptions being stored in each database application.
@x @x @x @x @x @x @x


B) data descriptions being stored on a server.
@x @x @x @x @x @x


C) data descriptions being written into programming code.
@x @x @x @x @x @x


D) data cohabiting with program
@x @x @x


s. Answer: A
@x @x


LO: 1.2: Name several limitations of conventional file processing syst
@ x @x @x @x @x @x @x @x @x


ems. Difficulty: Moderate
@x @x


Classification: Concept @ x


AACSB: Information Technology @ x @x




6) Because applications are often developed independently in file processing systems:
@x @x @x @x @x @x @x @x @x


A) the data is always non-redundant.
@x @x @x @x


B) unplanned duplicate data files are the rule rather than the exception.
@x @x @x @x @x @x @x @x @x @x


C) data can always be shared with others.
@x @x @x @x @x @x


D) there is a large volume of file I
@x @x @x @x @x @x @x


/O. Answer: B
@x @x


LO: 1.2: Name several limitations of conventional file processing syst
@ x @x @x @x @x @x @x @x @x


ems. Difficulty: Moderate
@x @x


Classification: Concept @ x


AACSB: Information Technology @ x @x




7) Relational databases establish the relationships between entities by means of common
@x @x @x @x @x @x @x @x @x @x @x


fields included in a file called a(n):
@x @x @x @x @x @x


A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
@x @x


LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ x @x @x @x @x @x @x @x @x @x @x @x @x @


file processing.
x @x


Difficulty: Moderate Classifi @x @x


cation: Concept @x


AACSB: Information Technology @ x @x




8) A(n)
is often developed by identifying a form or report that a user needs on a regular
@x @x @x @x @x @x @x @x @x @x @x @x @x @x @x @


xbasis.
A) enterprise view @x


B) reporting document @x


C) user view @x


D) user snapsho @x


t Answer: C
@x @x


LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ x @x @x @x @x @x @x @x @x @x @x @x @x @


file processing.
x @x

, 9) A graphical system used to capture the nature and relationships among data is called a(
@x @x @x @x @x @x @x @x @x @x @x @x @x @x


n):
A) XML data model.
@x @x


B) hypertext graphic. @x


C) relational database. @x


D) data model
@x


.
Answer: D @x


LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ x @x @x @x @x @x @x @x @x @x @x @x @x @


file processing.
x @x


Difficulty: Moderate Classifi
@x @x


cation: Concept
@x


AACSB: Information Technology
@ x @x




10) Data that describe the properties of other data are:
@x @x @x @x @x @x @x @x


A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
@x @x


LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ x @x @x @x @x @x @x @x @x @x @x @x @x @


file processing.
x @x


Difficulty: Moderate Classifi
@x @x


cation: Concept
@x


AACSB: Information Technology
@ x @x




11) Metatdata typically describes all of the following EXCEPT:
@x @x @x @x @x @x @x


A) data definitions.
@x


B) length.
C) allowable values. @x


D) location on dis @x @x


k.
Answer: D @ x


LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ x @x @x @x @x @x @x @x @x @x @x @x @x @


file processing.
x @x


Difficulty: Moderate Classifi
@x @x


cation: Concept
@x


AACSB: Information Technology
@ x @x




4
Copyright © 2019 Pearson Education, I
@x @x @x @x @x

nc.