TEST BANK FOR Modern Database Management 13th Edition by JEFFREY A HOFFER ISBN:978-0134773650 COMPLETE GUIDE ALL CHAPTERS COVERED 100% VERIFIED A+ GRADE ASSURED!!!!! NEW LATEST UPDATE!!!!!

TEST BANK
1a

,Modern Database Management, 13e (Hoffer)
1a 1a 1a 1a



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




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



more than:1a



A) 1 terabyte of data.
1a 1a 1a



B) 3 gigabytes of data.
1a 1a 1a



C) at least 100 petabytes of data.
1a 1a 1a 1a 1a



D) more than 7 billion exabytes of data.
1a 1a 1a 1a 1a 1a 1a



Answer: D 1a



LO: 1.1: Define key terms. Di
1 a 1a 1a 1a 1a



fficulty: Easy Classification:
1a 1a 1 a



Concept
AACSB: Information Technology
1 a 1a




2) Database management involves all of the following EXCEPT:
1a 1a 1a 1a 1a 1a 1a



A) collecting data. 1a



B) organizing data. 1a



C) design web pages. 1a 1a



D) managing data. 1a



Answer: C 1a



LO: 1.1: Define key terms. Di
1 a 1a 1a 1a 1a



fficulty: Easy Classification:
1a 1a 1 a



Concept
AACSB: Information Technology
1 a 1a




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



A) logically
B) physically
C) loosely
D) badly A 1a



nswer: A 1a



LO: 1.1: Define key terms. Di
1 a 1a 1a 1a 1a



fficulty: Easy Classification:
1a 1a 1 a



Concept
AACSB: Information Technology
1 a 1a




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



B) excellent; mainframes 1a



C) poor; mainframes 1a



D) excellent; workgroup computers 1a 1a 1a



Answer: C 1a



LO: 3.1: Define key terms.
1a 1a 1a 1a

,5) Program-data dependence is caused by: 1a 1a 1a 1a



A) file descriptions being stored in each database application.
1a 1a 1a 1a 1a 1a 1a



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



C) data descriptions being written into programming code.
1a 1a 1a 1a 1a 1a



D) data cohabiting with programs.
1a 1a 1a 1a



Answer: A 1a



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



Difficulty: Moderate 1a



Classification: Concept 1 a



AACSB: Information Technology 1 a 1a




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



A) the data is always non-redundant.
1a 1a 1a 1a



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



C) data can always be shared with others.
1a 1a 1a 1a 1a 1a



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



Answer: B 1a



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



Difficulty: Moderate 1a



Classification: Concept 1 a



AACSB: Information Technology 1 a 1a




7) Relational databases establish the relationships between entities by means of common fields i
1a 1a 1a 1a 1a 1a 1a 1a 1a 1a 1a 1a



ncluded in a file called a(n):
1a 1a 1a 1a 1a



A) entity.
B) relationship.
C) relation.
D) association. 1



Answer: C
a 1a



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



cessing.
Difficulty: Moderate Classific 1a 1a



ation: Concept
1a



AACSB: Information Technology 1 a 1a




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



A) enterprise view 1a



B) reporting document 1a



C) user view 1a



D) user snapshot 1a 1



Answer: C
a 1a



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



cessing.

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



A) XML data model. 1a 1a



B) hypertext graphic. 1a



C) relational database. 1a



D) data model. 1a



Answer: D 1a



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



cessing.
Difficulty: Moderate Classific 1a 1a



ation: Concept
1a



AACSB: Information Technology
1 a 1a




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



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



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



cessing.
Difficulty: Moderate Classific 1a 1a



ation: Concept
1a



AACSB: Information Technology
1 a 1a




11) Metatdata typically describes all of the following EXCEPT:
1a 1a 1a 1a 1a 1a 1a



A) data definitions.
1a



B) length.
C) allowable values. 1a



D) location on disk. 1a 1a



Answer: D 1 a



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



cessing.
Difficulty: Moderate Classific 1a 1a



ation: Concept
1a



AACSB: Information Technology
1 a 1a




4
Copyright © 2019 Pearson Education, Inc.