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

TEST BANK
Test Bank for Modern Database Management
13th Edition
EL
I TE
ST
U
D
IE
S


TEST BANK

,Jeffrey A. Hoffer, V. Ramesh & Heikki Topi: Modern Database Management



Chapter 1: The Database Environment and Development Process
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
more than:
A) 1 terabyte of data.
B) 3 gigabytes of data.
EL
C) at least 100 petabytes of data.
D) more than 7 billion exabytes of
data. Answer: D
LO: 1.1: Define key terms.
Difficulty: Easy
I
Classification: Concept
TE
AACSB: Information Technology


2) Database management involves all of the following EXCEPT:
A) collecting data.
ST
B) organizing data.
C) design web pages.
D) managing
data. Answer: C
U
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
D
AACSB: Information Technology
IE
3) A database is an organized collection of related data.
A) logically
B) physically
C) loosely
S
D) badly
Answer: A
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology

,4) Legacy systems often contain data of quality and are generally hosted on .
A) poor; personal computers
B) excellent; mainframes
C) poor; mainframes
D) excellent; workgroup
computers Answer: C
LO: 3.1: Define key terms.


5) Program-data dependence is caused by:
EL
A) file descriptions being stored in each database application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with
I
programs. Answer: A
TE
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
ST

6) Because applications are often developed independently in file processing systems:
A) the data is always non-redundant.
B) unplanned duplicate data files are the rule rather than the exception.
U
C) data can always be shared with others.
D) there is a large volume of file I/O.
Answer: B
D
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
IE
Classification: Concept
AACSB: Information Technology

7) Relational databases establish the relationships between entities by means of common
S
fields included in a file called a(n):
A) entity.
B) relationship.
C) relation.
D) association
. Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.

, Difficulty: Moderate
Classification: Concept
AACSB: Information Technology

8) A(n) is often developed by identifying a form or report that a user needs on
a regular basis.
A) enterprise view
B) reporting document
C) user view
D) user
EL
snapshot
Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.
I TE
9) A graphical system used to capture the nature and relationships among data is called a(n):
A) XML data model.
B) hypertext graphic.
C) relational database.
ST
D) data
model.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.
U
Difficulty: Moderate
Classification: Concept
D
AACSB: Information Technology
IE
10) Data that describe the properties of other data are:
A) relationships.
B) logical.
C) physical.
S
D) metadata
. Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology