Test Bank for Modern Database Management, 13th Edition, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi ,ISBN: 9780134877006, Chapter 1-14 Complete Guide A+

TEST BANK 70




MODERN70DATABASE70MANAGEMENT,7013TH70EDITION
Jeff70Hoffer,70Ramesh70Venkataraman,70Heikki70Topi

,Modern70Database70Management,7013e70(Hoffer)
Chapter7017 0 7 0 The70Database70Environment70and70Development70Process

1) According70to70a70McKinsey70Global70Institute70Report,70in70201070alone,70global70enterpr
ises70stored70more70than:
A) 170terabyte70of70data.
B) 370gigabytes70of70data.
C) at70least7010070petabytes70of70data.
D) more70than70770billion70exabytes70of7
0data.70Answer:7 0 D
LO:7 0 1.1:70Define70key70term
s.70Difficulty:7 0 Easy70Classifi
cation:7 0 Concept
AACSB:7 0 Information70Technology

2) Database70management70involves70all70of70the70following70EXCEPT:
A) collecting70data.
B) organizing70data.
C) design70web70pages.
D) managing70dat
a.70Answer:7 0 C
LO:7 0 1.1:70Define70key70term
s.70Difficulty:7 0 Easy70Classifi
cation:7 0 Concept
AACSB:7 0 Information70Technology

3) A70database70is70an70organized70collection70of70 related70data.
A) logically
B) physically
C) loosely
D) badly70
Answer:7 0
A
LO:7 0 1.1:70Define70key70term
s.70Difficulty:7 0 Easy70Classifi
cation:7 0 Concept
AACSB:7 0 Information70Technology

4) Legacy70systems70often70contain70data70of70 quality70and70are70generally70hosted70on70 .
A) poor;70personal70computers
B) excellent;70mainframes
C) poor;70mainframes
D) excellent;70workgroup70compute
rs70Answer:7 0 C
LO:7 0 3.1:70Define70key70term
s.70Difficulty:7 0 Moderate70Cl
assification:7 0 Concept
1
Copyright70©70201970Pearson70Education,
70Inc.

,AACSB:7 0 Information70Technology




2
Copyright70©70201970Pearson70Education,
70Inc.

, 5) Program-data70dependence70is70caused70by:
A) file70descriptions70being70stored70in70each70database70application.
B) data70descriptions70being70stored70on70a70server.
C) data70descriptions70being70written70into70programming70code.
D) data70cohabiting70with70progra
ms.70Answer:7 0 A
LO:7 0 1.2:70Name70several70limitations70of70conventional70file70processing70
systems.70Difficulty:7 0 Moderate
Classification:7 0 Concept
AACSB:7 0 Information70Technology

6) Because70applications70are70often70developed70independently70in70file70processing70systems:
A) the70data70is70always70non-redundant.
B) unplanned70duplicate70data70files70are70the70rule70rather70than70the70exception.
C) data70can70always70be70shared70with70others.
D) there70is70a70large70volume70of70fil
e70I/O.70Answer:7 0 B
LO:7 0 1.2:70Name70several70limitations70of70conventional70file70processing70
systems.70Difficulty:7 0 Moderate
Classification:7 0 Concept
AACSB:7 0 Information70Technology

7) Relational70databases70establish70the70relationships70between70entities70by70means70of70com
mon70fields70included70in70a70file70called70a(n):
A) entity.
B) relationship.
C) relation.
D) association.
70Answer:7 0 C
LO:7 0 1.3:70Explain70at70least701070advantages70of70the70database70approach,70compared70to70traditi
onal70file70processing.
Difficulty:7 0 Moderate70Classi
fication:7 0 Concept
AACSB:7 0 Information70Technology

8) A(n)70
is70often70developed70by70identifying70a70form70or70report70that70a70user70needs70on70a70
regular70basis.
A) enterprise70view
B) reporting70document
C) user70view
D) user70snapsh
ot70Answer:7 0 C
LO:7 0 1.3:70Explain70at70least701070advantages70of70the70database70approach,70compared70to70traditi
onal70file70processing.
Difficulty:7 0 Moderate70Classi
fication:7 0 Concept
3
Copyright70©70201970Pearson70Education,
70Inc.