test bank for modern database management 13th edition heikki topi jeffrey a hoffer ramesh venkataraman

TESTBANK u




MODERN DATABASE MANAGEMENT, 13TH EDITION
u u u u




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
u u u u u

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




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




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




more than:
u u




A) 1 terabyte of data.
u u u




B) 3 gigabytes of data.
u u u




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




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




Answer: D
u u




LO: 1.1: Define keyterms.
u u u u




Difficulty: Easy
u u




Classification: Concept
u u




AACSB: Information Technology u u




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




A) collecting data. u




B) organizing data. u




C) design web pages. u u




D) managing data. u




Answer: C
u u




LO: 1.1: Define keyterms.
u u u u




Difficulty: Easy
u u




Classification: Concept
u u




AACSB: Information Technology u u




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




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




LO: 1.1: Define keyterms.
u u u u




Difficulty: Easy
u u




Classification: Concept
u u




AACSB: Information Technology u u




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




B) excellent; mainframes u




C) poor; mainframes
u




D) excellent; workgroupcomputers u u




Answer: C
u u




LO: 3.1: Define keyterms.
u u u u




Difficulty: Moderate
u u




Classification: Concept
u u




AACSB: Information Technology u u




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

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




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




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




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




D) datacohabiting withprograms.
u u u




Answer: A
u u




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




Difficulty: Moderate
u u




Classification: Concept u




AACSB: Information Technology u u




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




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




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




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




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




Answer: B
u u




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




Difficulty: Moderate
u u




Classification: Concept u




AACSB: Information Technology u u




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




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




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




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




processing.
u




Difficulty: Moderate u




Classification: Concept
u u




AACSB: Information Technology u u




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




regular basis.
u u




A) enterprise view u




B) reporting document u




C) user view u




D) usersnapshot u




Answer: C
u u




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




processing.
u




Difficulty: Moderate u




Classification: Concept
u u




AACSB: Information Technology u u




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

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




A) XML data model.
u u




B) hypertext graphic. u




C) relational database. u




D) datamodel.
u




Answer: D
u u




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




processing.
u




Difficulty: Moderate u




Classification: Concept
u u




AACSB: Information Technology
u u




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




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




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




processing.
u




Difficulty: Moderate u




Classification: Concept
u u




AACSB: Information Technology
u u




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




A) data definitions.
u




B) length.
C) allowable values. u




D) location on disk. u u




Answer: D u




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




processing.
u




Difficulty: Moderate u




Classification: Concept
u u




AACSB: Information Technology
u u




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