Test Bank For Modern Database Management 13Th Edition By Heikki Topi Jeffrey A. Hoffer Ramesh Venkataraman All Chapters Included 2024 Latest Update.

TESTBANK n




MODERN DATABASE MANAGEMENT, 13TH EDITION
n n n n




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
n n n n n

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




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




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




more than:
n n




A) 1 terabyte of data.
n n n




B) 3 gigabytes of data.
n n n




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




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




Answer: D
n n




LO: 1.1: Define keyterms.
n n n n




Difficulty: Easy
n n




Classification: Concept
n n




AACSB: Information Technology n n




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




A) collecting data. n




B) organizing data. n




C) design web pages. n n




D) managing data. n




Answer: C
n n




LO: 1.1: Define keyterms.
n n n n




Difficulty: Easy
n n




Classification: Concept
n n




AACSB: Information Technology n n




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




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




LO: 1.1: Define keyterms.
n n n n




Difficulty: Easy
n n




Classification: Concept
n n




AACSB: Information Technology n n




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




B) excellent; mainframes n




C) poor; mainframes
n




D) excellent; workgroupcomputers n n




Answer: C
n n




LO: 3.1: Define keyterms.
n n n n




Difficulty: Moderate
n n




Classification: Concept
n n




AACSB: Information Technology n n




1
Copyright © 2019 Pearson Education, Inc.
n n n n n

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




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




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




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




D) datacohabiting withprograms.
n n n




Answer: A
n n




LO: 1.2: Name several limitations ofconventional file processing systems.
n n n n n n n n n




Difficulty: Moderate
n n




Classification: Concept n




AACSB: Information Technology n n




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




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




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




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




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




Answer: B
n n




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




Difficulty: Moderate
n n




Classification: Concept n




AACSB: Information Technology n n




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




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




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




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




processing.
n




Difficulty: Moderate n




Classification: Concept
n n




AACSB: Information Technology n n




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




regular basis.
n n




A) enterprise view n




B) reporting document n




C) user view n




D) usersnapshot n




Answer: C
n n




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




processing.
n




Difficulty: Moderate n




Classification: Concept
n n




AACSB: Information Technology n n




2
Copyright © 2019 Pearson Education, Inc. n n n n n

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




A) XML data model.
n n




B) hypertext graphic. n




C) relational database. n




D) datamodel.
n




Answer: D
n n




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




processing.
n




Difficulty: Moderate n




Classification: Concept
n n




AACSB: Information Technology
n n




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




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




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




processing.
n




Difficulty: Moderate n




Classification: Concept
n n




AACSB: Information Technology
n n




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




A) data definitions.
n




B) length.
C) allowable values. n




D) location on disk. n n




Answer: D n




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




processing.
n




Difficulty: Moderate n




Classification: Concept
n n




AACSB: Information Technology
n n




3
Copyright © 2019 Pearson Education, Inc.
n n n n n