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)
ib ib ib ib



Chapter 1 The Database Environment and Development Process
ib i b ib ib ib ib ib




1) According to a McKinsey Global InstituteReport, in2010 alone, globalenterprises stored mo
ib ib ib ib ib ib ib ib ib ib ib ib ib



re than:
ib



A) 1 terabyte of data.
ib ib ib



B) 3 gigabytes of data.
ib ib ib



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



D) morethan 7 billion exabytes ofdata.
ib ib ib ib ib ib ib



Answer: D ib



LO: 1.1:Define keyterms. Di f
i b ib ib ib ib ib



ficulty: Easy Classification:
ib ib



Concept
AACSB: Information Technology i b ib




2) Database management involves allofthe following EXCEPT: ib ib ib ib ib ib ib



A) collecting data. ib



B) organizing data. ib



C) design web pages. 1a ib



D) managingdata. ib ib



Answer: C ib



LO: 1.1:Define keyterms. Di f
i b ib ib ib ib ib



ficulty: Easy Classification:
ib ib



Concept
AACSB: Information Technology i b ib




3) Adatabase is an organized collection of
ib ib ib ib ib ib related data. ib



A) logically
B) physically
C) loosely
D) badly A ib ib



nswer: A ib



LO: 1.1:Define keyterms. Di f
i b ib ib ib ib ib



ficulty: Easy Classification:
ib ib



Concept
AACSB: Information Technology i b ib




4) Legacysystems often contain data of ib ib ib ib ib quality and are generally hosted on
ib ib ib ib ib .
A) poor; personal computers ib ib



B) excellent; mainframes ib



C) poor;mainframes ib



D) excellent; workgroupcomputers ib ib ib



Answer: C ib



LO: 3.1: Define key terms.
ib ib ib ib

,5) Program-datadependence is caused by: ib ib ib 1a



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



B) datadescriptions being stored on a server.
ib ib ib 1a ib ib



C) datadescriptions being written into programming code.
ib ib ib ib 1a ib



D) data cohabitingwith programs.
1a ib 1a ib



Answer: A ib



LO: 1.2:Name severallimitations ofconventional file processing systems. Diffic
i b ib ib ib ib ib ib ib 1a ib



ulty: Moderate
ib



Classification: Concept i b



AACSB: Information Technology i b ib




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



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



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



C) datacan always be shared with others.
ib ib ib ib ib ib



D) there is a large volumeoffile I/O.
ib 1a ib ib ib ib ib ib



Answer: B ib



LO: 1.2: Name severallimitations ofconventional file processing systems. Diffic
i b ib ib ib ib ib ib ib ib ib



ulty: Moderate
ib



Classification: Concept i b



AACSB: Information Technology i b ib




7) Relationaldatabases establish the relationships between entities bymeans ofcommon fields i nc
ib ib ib ib ib 1a ib ib ib ib ib ib ib



luded in a file called a(n):
ib ib ib ib ib



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



bAnswer: C ib



LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
i b ib ib ib ib ib ib ib ib ib ib ib ib ib ib ib



Difficulty: Moderate Classific ib ib ib



ation: Concept
ib



AACSB: Information Technology i b ib




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



A) enterprise view ib



B) reporting document ib



C) user view ib



D) usersnapshot ib



Answer: C ib



LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
i b ib ib ib ib ib ib ib ib ib ib ib ib ib ib ib

, 9) Agraphical systemused to capturethe nature and relationships among data is called a(n):
ib ib ib ib ib ib ib ib ib ib ib ib ib ib



A) XMLdata model. ib ib



B) hypertext graphic. 1a



C) relational database. ib



D) data model. ib i



Answer: D
b ib



LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
i b ib ib ib ib ib ib ib ib ib ib 1a ib ib ib ib



Difficulty: Moderate Classific ib ib ib



ation: Conceptib



AACSB: Information Technology i b ib




10) Datathat describe the properties ofother data are:
ib ib ib ib ib ib ib ib



A) relationships.
B) logical.
C) physical.
D) metadata. i



Answer: D
b ib



LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
i b ib ib ib ib ib ib ib ib ib ib ib ib ib ib ib



Difficulty: Moderate Classific ib ib ib



ation: Conceptib



AACSB: Information Technology i b ib




11) Metatdatatypically describes all of the following EXCEPT: ib ib ib ib ib ib ib



A) data definitions.
1a



B) length.
C) allowable values. ib



D) locationon disk. ib 1a ib



Answer: D i b



LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
i b ib ib ib ib ib ib ib ib ib ib ib ib ib ib ib



Difficulty: Moderate Classific ib ib ib



ation: Conceptib



AACSB: Information Technology i b ib




4
Copyright © 2019 Pearson Education, Inc.
ib ib ib ib ib