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

TEST BANK
g

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


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




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


more than:
g g


A) 1 terabyte of data.
g g g


B) 3 gigabytes of data.
g g g


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


D) more than 7 billion exabytes of data.
g g g g g g


Answer: D
g g


LO: 1.1: Define key terms.
g g g g


Difficulty: Easy
g g


Classification: Concept
g g


AACSB: Information Technology g g




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


A) collecting data. g


B) organizing data. g


C) design web pages. g g


D) managing data. g


Answer: C g


LO: 1.1: Define key terms.
g g g g


Difficulty: Easy
g g


Classification: Concept
g g


AACSB: Information Technology g g




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


A) logically
B) physically
C) loosely
D) badly
Answer:
g


A
g


LO: 1.1: Define key terms.
g g g g


Difficulty: Easy
g g


Classification: Concept
g g


AACSB: Information Technology g g




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


B) excellent; mainframes g


C) poor; mainframes g


D) excellent; workgroup computers g g


Answer: C
g g


LO: 3.1: Define key terms.
g g g g

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


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


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


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


D) data cohabiting with programs.
g g g


Answer: A
g g


LO: 1.2: Name several limitations of conventional file processing systems.
g g g g g g g g g


Difficulty: Moderate
g g


Classification: Concept g


AACSB: Information Technology
g g




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


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


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


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


D) there is a large volume of file I/O.
g g g g g g g


Answer: B
g g


LO: 1.2: Name several limitations of conventional file processing systems.
g g g g g g g g g


Difficulty: Moderate
g g


Classification: Concept g


AACSB: Information Technology
g g




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


included in a file called a(n):
g g g g g g


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


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


processing.
g


Difficulty: Moderate g


Classification: Concept
g g


AACSB: Information Technology
g g




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


regular basis.
g g


A) enterprise view g


B) reporting document g


C) user viewg


D) user snapshot
g


Answer: C
g g


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


processing.
g

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


A) XML data model.
g g


B) hypertext graphic. g


C) relational database. g


D) data model.
g


Answer: D g


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


processing.
g


Difficulty: Moderate g


Classification: Concept
g g


AACSB: Information Technology
g g




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


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


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


processing.
g


Difficulty: Moderate g


Classification: Concept
g g


AACSB: Information Technology
g g




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


A) data definitions.
g


B) length.
C) allowable values. g


D) location on disk. g g


Answer: D g


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


processing.
g


Difficulty: Moderate g


Classification: Concept
g g


AACSB: Information Technology
g g




4
Copyright © 2019 Pearson Education, Inc.
g g g g g