TEST BANK For Modern Database Management, 13th Edition By Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, All Chapters 1 - 14, Complete Newest Version

TEST BANK
b9

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


Chapter 1 The Database Environment and Development Process
b9 b 9 b9 b9 b9 b9 b9




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


stored more than:
b9 b9 b9



A) 1 terabyte of data.
b9 b9 b9


B) 3 gigabytes of data.
b9 b9 b9



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


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


data. Answer: D
b9 b9 b9


LO: 1.1: Define key terms.
b 9 b9 b9 b9


Difficulty: Easy
b9 b9


Classification: Concept
b9 b 9


AACSB: Information Technology b 9 b9




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


A) collecting data. b9


B) organizing data. b9


C) design web pages. b9 b9


D) managing
data.
b9


Answer: C b9


LO: 1.1: Define key terms.
b 9 b9 b9 b9


Difficulty: Easy
b9 b9


Classification: Concept
b9 b 9


AACSB: Information Technology b 9 b9




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


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


A
b9


LO: 1.1: Define key terms.
b 9 b9 b9 b9


Difficulty: Easy
b9 b9


Classification: Concept
b9 b 9


AACSB: Information Technology b 9 b9




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


B) excellent; mainframes b9



C) poor; mainframes b9


D) excellent; workgroup computers b9 b9


Answer: C
b9 b9


LO: 3.1: Define key terms.
b9 b9 b9 b9

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


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


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


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


D) data cohabiting with
b9 b9


programs. Answer: A
b9 b9 b9


LO: 1.2: Name several limitations of conventional file processing
b 9 b9 b9 b9 b9 b9 b9 b9


systems. Difficulty: Moderate
b9 b9 b9


Classification: Concept b 9


AACSB: Information Technology b 9 b9




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


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


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


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


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


I/O. Answer: B
b9 b9 b9


LO: 1.2: Name several limitations of conventional file processing
b 9 b9 b9 b9 b9 b9 b9 b9


systems. Difficulty: Moderate
b9 b9 b9


Classification: Concept b 9


AACSB: Information Technology b 9 b9




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


b9fields included in a file called a(n):
b9 b9 b9 b9 b9 b9


A) entity.
B) relationship.
C) relation.
D) association.
b9Answer: C b9


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


file processing.
b9 b9


Difficulty: Moderate b9


b9Classification: Concept b9



AACSB: Information Technology b 9 b9




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


b9on a regular basis.
b9 b9 b9


A) enterprise view b9



B) reporting document b9


C) user view b9


D) user snapshot b9


b9Answer: C b9


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


file processing.
b9 b9

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


A) XML data model. b9 b9


B) hypertext graphic. b9


C) relational database. b9


D) data
model.
b9


Answer: D b9


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


file processing.
b9 b9


Difficulty: Moderate b9


b9Classification: Concept b9


AACSB: Information Technology
b 9 b9




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


A) relationships.
B) logical.
C) physical.
D) metadata.
b9Answer: D b9


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


file processing.
b9 b9


Difficulty: Moderate b9


b9Classification: Concept b9


AACSB: Information Technology
b 9 b9




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


A) data definitions.
b9


B) length.
C) allowable values. b9


D) location on b9


disk.
b9


Answer: D b 9


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


file processing.
b9 b9


Difficulty: Moderate b9


b9Classification: Concept b9


AACSB: Information Technology
b 9 b9




4
Copyright © 2019 Pearson Education, Inc.