Test Bank for Modern Database Management 13th Edition by Hoffer, Ramesh, and Topi

TEST BANK
@q

,
,Modern Database Management, 13e (Hoffer)
@q @q @q @q


Chapter 1 The Database Environment and Development Process
@q @ q @q @q @q @q @q




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


stored more than: @q @q


A) 1 terabyte of data.
@q @q @q


B) 3 gigabytes of data.
@q @q @q


C) at least 100 petabytes of data.
@q @q @q @q @q


D) more than 7 billion exabytes of da
@q @q @q @q @q @q


ta. Answer: D
@q @q


LO: 1.1: Define key terms.
@ q @q @q @q @


qDifficulty: Easy Classificati @q @q


on: Concept
@ q


AACSB: Information Technology
@ q @q




2) Database management involves all of the following EXCEPT:
@q @q @q @q @q @q @q


A) collecting data. @q


B) organizing data. @q


C) design web pages. @q @q


D) managing data @q


.
Answer: C @q


LO: 1.1: Define key terms.
@ q @q @q @q @


Difficulty: Easy Classificati
q @q @q


on: Concept
@ q


AACSB: Information Technology
@ q @q




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


A) logically
B) physically
C) loosely
D) badly @q


Answer: @q


A
LO: 1.1: Define key terms.
@ q @q @q @q @


Difficulty: Easy Classificati
q @q @q


on: Concept
@ q


AACSB: Information Technology
@ q @q




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


B) excellent; mainframes @q


C) poor; mainframes @q


D) excellent; workgroup computer @q @q


s Answer: C
@q @q


LO: 3.1: Define key terms.
@q @q @q @q

, 5) Program-data dependence is caused by: @q @q @q @q


A) file descriptions being stored in each database application.
@q @q @q @q @q @q @q


B) data descriptions being stored on a server.
@q @q @q @q @q @q


C) data descriptions being written into programming code.
@q @q @q @q @q @q


D) data cohabiting with program
@q @q @q


s. Answer: A
@q @q


LO: 1.2: Name several limitations of conventional file processing syst
@ q @q @q @q @q @q @q @q @q


ems. Difficulty: Moderate
@q @q


Classification: Concept @ q


AACSB: Information Technology @ q @q




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


A) the data is always non-redundant.
@q @q @q @q


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


C) data can always be shared with others.
@q @q @q @q @q @q


D) there is a large volume of file I
@q @q @q @q @q @q @q


/O. Answer: B
@q @q


LO: 1.2: Name several limitations of conventional file processing syst
@ q @q @q @q @q @q @q @q @q


ems. Difficulty: Moderate
@q @q


Classification: Concept @ q


AACSB: Information Technology @ q @q




7) Relational databases establish the relationships between entities by means of common
@q @q @q @q @q @q @q @q @q @q @q


fields included in a file called a(n):
@q @q @q @q @q @q


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


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


file processing.
q @q


Difficulty: Moderate Classifi @q @q


cation: Concept @q


AACSB: Information Technology @ q @q




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


qbasis.
A) enterprise view @q


B) reporting document @q


C) user view @q


D) user snapsho @q


t Answer: C
@q @q


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


file processing.
q @q