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!!!!!

TESTBANK

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



Chapter 1 The Database Environment and Development Process
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% n



Answer: D
% n%



LO: 1.1: Define key terms. Di
n % n% n% n% n% n



fficulty: Easy Classification:
% n% n%



Concept
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. 1a n%



D) managing data. n%



Answer: C
n% n%



LO: 1.1: Define key terms. Di
n % n% n% n% n% n



fficulty: Easy Classification:
% n% n%



Concept
AACSB: Information Technology n % n%




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



A) logically
B) physically
C) loosely
D) badly A n%



nswer: A
n% n%



LO: 1.1: Define key terms. Di
n % n% n% n% n% n



fficulty: Easy Classification:
% n% n%



Concept
AACSB: Information Technology n % n%




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



B) excellent; mainframes n%



C) poor; mainframes n%



D) excellent; workgroup computers n% n% n



Answer: C
% n%



LO: 3.1: Define key terms.
n% n% n% n%

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



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% 1a n% n%



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



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



Answer: A n%



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



fficulty: Moderate 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% 1a n% n% n% n% n%



Answer: B
n% n%



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



fficulty: Moderate n%



Classification: Concept n %



AACSB: Information Technology
n % n%




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



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



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



%Answer: C n%



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



sing.
Difficulty: Moderate Classific n% n% n



%ation: Concept
n%



AACSB: Information Technology
n % n%




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



A) enterprise view n%



B) reporting document n%



C) user view n%



D) usersnapshot n



%Answer: C n%



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



sing.

, 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. 1a



C) relational database. n%



D) data model. n%



Answer: D
n% n%



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



sing.
Difficulty: Moderate Classific n% n% n



%ation: Conceptn%



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 pro ces
n % n% n% n% n% n% n% n% n% n% n% n% n% n% n% n%



sing.
Difficulty: Moderate Classific n% n% n



%ation: Conceptn%



AACSB: Information Technology
n % n%




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



A) data definitions.1a



B) length.
C) allowable values. n%



D) location on disk. n% 1a n



%Answer: D n %



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



sing.
Difficulty: Moderate Classific n% n% n



%ation: Conceptn%



AACSB: Information Technology
n % n%




4
Copyright © 2019 Pearson Education, Inc.