Test Bank for Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi ISBN: 9780134877006 Chapter 1-14 Complete Guide.

TEST BANK
w

,Modern Database Management, 13e (Hoffer)
w w w w


Chapter 1 The Database Environment and Development Process
w w w w w w w




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


wstored more than: w w


A) 1 terabyte of data.
w w w


B) 3 gigabytes of data.
w w w


C) at least 100 petabytes of data.
w w w w w


D) more than 7 billion exabytes of
w w w w w


data. Answer: D
w w w


LO: 1.1: Define key terms.
w w w w


wDifficulty: Easy w


wClassification: Concept w


AACSB: Information Technology
w w




2) Database management involves all of the following EXCEPT:
w w w w w w w


A) collecting data. w


B) organizing data. w


C) design web pages. w w


D) managing
data.
w


Answer: C w


LO: 1.1: Define key terms.
w w w w


wDifficulty: Easy w


wClassification: Concept w


AACSB: Information Technology
w w




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


A) logically
B) physically
C) loosely
D) badly
wAnswer: A w


LO: 1.1: Define key terms.
w w w w


wDifficulty: Easy w


wClassification: Concept w


AACSB: Information Technology
w w




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


B) excellent; mainframes w


C) poor; mainframes w


D) excellent; workgroup w


computers Answer: C
w w w


LO: 3.1: Define key terms.
w w w w

,5) Program-data dependence is caused by: w w w w


A) file descriptions being stored in each database application.
w w w w w w w


B) data descriptions being stored on a server.
w w w w w w


C) data descriptions being written into programming code.
w w w w w w


D) data cohabiting with w w


programs. Answer: A
w w w


LO: 1.2: Name several limitations of conventional file processing
w w w w w w w w


wsystems. Difficulty: Moderate w w


Classification: Concept w


AACSB: Information Technology
w w




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


A) the data is always non-redundant.
w w w w


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


C) data can always be shared with others.
w w w w w w


D) there is a large volume of file
w w w w w w


wI/O. Answer: B
w w


LO: 1.2: Name several limitations of conventional file processing
w w w w w w w w


systems. Difficulty: Moderate
w w w


Classification: Concept w


AACSB: Information Technology
w w




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


wfields included in a file called a(n):
w w w w w w


A) entity.
B) relationship.
C) relation.
D) association.
wAnswer: C w


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


file processing.
w w


Difficulty: Moderate w


wClassification: Concept w


AACSB: Information Technology
w w




8) A(n) is often developed by identifying a form or report that a user needs
w w w w w w w w w w w w


won a regular basis.
w w w


A) enterprise view w


B) reporting document w


C) user view w


D) user
snapshot
w


wAnswer: C w


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


file processing.
w w

, 9) A graphical system used to capture the nature and relationships among data is called a(n):
w w w w w w w w w w w w w w


A) XML data model.
w w


B) hypertext graphic. w


C) relational database. w


D) data
model.
w


Answer: D w


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


file processing.
w w


Difficulty: Moderate w


wClassification: Concept w


AACSB: Information Technology
w w




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


A) relationships.
B) logical.
C) physical.
D) metadat
a. Answer:
w


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


file processing.
w w


Difficulty: Moderate w


wClassification: Concept w


AACSB: Information Technology
w w




11) Metatdata typically describes all of the following EXCEPT:
w w w w w w w


A) data definitions.
w


B) length.
C) allowable values. w


D) location on disk. w w


Answer: D w


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


file processing.
w w


Difficulty: Moderate w


wClassification: Concept w


AACSB: Information Technology
w w




4
Copyright © 2019 Pearson Education,
w w w w

Inc.