Modern Database Management 13th Edition Test Bank | Topi, Hoffer & Venkataraman Complete Guide

TEST BANK
MODERN DATABASE MANAGEMENT, 13TH EDITION
Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

,Modern Database Management, 13e (Hoffer)
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.
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.
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
C) loosely
D) badly
Answer: A
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology

4) Legacy systems often contain data of quality and are generally hosted on .
A) poor; personal computers
B) excellent; mainframes
C) poor; mainframes
D) excellent; workgroup computers
Answer: C
LO: 3.1: Define key terms.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
1
Copyright © 2019 Pearson Education, Inc.

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



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



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



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



D) data cohabiting with programs.
B B B



Answer: A
B B



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



Difficulty: Moderate
B B



Classification: Concept B



AACSB: Information Technology
B B




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



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



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



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



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



Answer: B
B B



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



Difficulty: Moderate
B B



Classification: Concept B



AACSB: Information Technology
B B




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



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



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



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



processing.
B



Difficulty: Moderate B



Classification: Concept
B B



AACSB: Information Technology
B B




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



regular basis.
B B



A) enterprise view B



B) reporting document B



C) user viewB



D) user snapshot
B



Answer: C
B B



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



processing.
B



Difficulty: Moderate B



Classification: Concept
B B



AACSB: Information Technology
B B




2
Copyright © 2019 Pearson Education, Inc.

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



A) XML data model.
B B



B) hypertext graphic. B



C) relational database. B



D) data model.
B



Answer: D
B B



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



processing.
B



Difficulty: Moderate B



Classification: Concept
B B



AACSB: Information Technology
B B




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



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



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



processing.
B



Difficulty: Moderate B



Classification: Concept
B B



AACSB: Information Technology
B B




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



A) data definitions.
B



B) length.
C) allowable values. B



D) location on disk. B B



Answer: D B



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



processing.
B



Difficulty: Moderate B



Classification: Concept
B B



AACSB: Information Technology
B B




3
Copyright © 2019 Pearson Education, Inc.