,Modern Database Management, 14e (Hoffer)
@1 @1 @1 @1
Chapter 1 The Database Environment and Development Process
@1 @ 1 @1 @1 @1 @1 @1
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1
stored more than: @1 @1
A) 1 terabyte of data.
@1 @1 @1
B) 3 gigabytes of data.
@1 @1 @1
C) at least 100 petabytes of data.
@1 @1 @1 @1 @1
D) more than 7 billion exabytes of da
@1 @1 @1 @1 @1 @1
ta. Answer: D
@1 @1
LO: 1.1: Define key terms.
@ 1 @1 @1 @1 @
1Difficulty: Easy Classificati @1 @1
on: Concept
@ 1
AACSB: Information Technology
@ 1 @1
2) Database management involves all of the following EXCEPT:
@1 @1 @1 @1 @1 @1 @1
A) collecting data. @1
B) organizing data. @1
C) design web pages. @1 @1
D) managing data @1
.
Answer: C @1
LO: 1.1: Define key terms.
@ 1 @1 @1 @1 @
Difficulty: Easy Classificati
1 @1 @1
on: Concept
@ 1
AACSB: Information Technology
@ 1 @1
3) A database is an organized collection of
@1 @1 @1 @1 @1 @1 related data. @1
A) logically
B) physically
C) loosely
D) badly @1
Answer: @1
A
LO: 1.1: Define key terms.
@ 1 @1 @1 @1 @
Difficulty: Easy Classificati
1 @1 @1
on: Concept
@ 1
AACSB: Information Technology
@ 1 @1
4) Legacy systems often contain data of
@1 @1 @1 @1 @1 quality and are generally hosted on
@1 @1 @1 @1 @1 .
A) poor; personal computers
@1 @1
B) excellent; mainframes @1
C) poor; mainframes @1
D) excellent; workgroup computer @1 @1
s Answer: C
@1 @1
LO: 3.1: Define key terms.
@1 @1 @1 @1
,5) Program-data dependence is caused by: @1 @1 @1 @1
A) file descriptions being stored in each database application.
@1 @1 @1 @1 @1 @1 @1
B) data descriptions being stored on a server.
@1 @1 @1 @1 @1 @1
C) data descriptions being written into programming code.
@1 @1 @1 @1 @1 @1
D) data cohabiting with program
@1 @1 @1
s. Answer: A
@1 @1
LO: 1.2: Name several limitations of conventional file processing syst
@ 1 @1 @1 @1 @1 @1 @1 @1 @1
ems. Difficulty: Moderate
@1 @1
Classification: Concept @ 1
AACSB: Information Technology @ 1 @1
6) Because applications are often developed independently in file processing systems:
@1 @1 @1 @1 @1 @1 @1 @1 @1
A) the data is always non-redundant.
@1 @1 @1 @1
B) unplanned duplicate data files are the rule rather than the exception.
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1
C) data can always be shared with others.
@1 @1 @1 @1 @1 @1
D) there is a large volume of file I
@1 @1 @1 @1 @1 @1 @1
/O. Answer: B
@1 @1
LO: 1.2: Name several limitations of conventional file processing syst
@ 1 @1 @1 @1 @1 @1 @1 @1 @1
ems. Difficulty: Moderate
@1 @1
Classification: Concept @ 1
AACSB: Information Technology @ 1 @1
7) Relational databases establish the relationships between entities by means of common
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1
fields included in a file called a(n):
@1 @1 @1 @1 @1 @1
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
@1 @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi @1 @1
cation: Concept @1
AACSB: Information Technology @ 1 @1
8) A(n)
is often developed by identifying a form or report that a user needs on a regular
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
1basis.
A) enterprise view @1
B) reporting document @1
C) user view @1
D) user snapsho @1
t Answer: C
@1 @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
, 9) A graphical system used to capture the nature and relationships among data is called a(
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1
n):
A) XML data model.
@1 @1
B) hypertext graphic. @1
C) relational database. @1
D) data model
@1
.
Answer: D @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi
@1 @1
cation: Concept
@1
AACSB: Information Technology
@ 1 @1
10) Data that describe the properties of other data are:
@1 @1 @1 @1 @1 @1 @1 @1
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
@1 @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi
@1 @1
cation: Concept
@1
AACSB: Information Technology
@ 1 @1
11) Metatdata typically describes all of the following EXCEPT:
@1 @1 @1 @1 @1 @1 @1
A) data definitions.
@1
B) length.
C) allowable values. @1
D) location on dis @1 @1
k.
Answer: D @ 1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi
@1 @1
cation: Concept
@1
AACSB: Information Technology
@ 1 @1
4
Copyright © 2019 Pearson Education, I
@1 @1 @1 @1 @1
nc.
@1 @1 @1 @1
Chapter 1 The Database Environment and Development Process
@1 @ 1 @1 @1 @1 @1 @1
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1
stored more than: @1 @1
A) 1 terabyte of data.
@1 @1 @1
B) 3 gigabytes of data.
@1 @1 @1
C) at least 100 petabytes of data.
@1 @1 @1 @1 @1
D) more than 7 billion exabytes of da
@1 @1 @1 @1 @1 @1
ta. Answer: D
@1 @1
LO: 1.1: Define key terms.
@ 1 @1 @1 @1 @
1Difficulty: Easy Classificati @1 @1
on: Concept
@ 1
AACSB: Information Technology
@ 1 @1
2) Database management involves all of the following EXCEPT:
@1 @1 @1 @1 @1 @1 @1
A) collecting data. @1
B) organizing data. @1
C) design web pages. @1 @1
D) managing data @1
.
Answer: C @1
LO: 1.1: Define key terms.
@ 1 @1 @1 @1 @
Difficulty: Easy Classificati
1 @1 @1
on: Concept
@ 1
AACSB: Information Technology
@ 1 @1
3) A database is an organized collection of
@1 @1 @1 @1 @1 @1 related data. @1
A) logically
B) physically
C) loosely
D) badly @1
Answer: @1
A
LO: 1.1: Define key terms.
@ 1 @1 @1 @1 @
Difficulty: Easy Classificati
1 @1 @1
on: Concept
@ 1
AACSB: Information Technology
@ 1 @1
4) Legacy systems often contain data of
@1 @1 @1 @1 @1 quality and are generally hosted on
@1 @1 @1 @1 @1 .
A) poor; personal computers
@1 @1
B) excellent; mainframes @1
C) poor; mainframes @1
D) excellent; workgroup computer @1 @1
s Answer: C
@1 @1
LO: 3.1: Define key terms.
@1 @1 @1 @1
,5) Program-data dependence is caused by: @1 @1 @1 @1
A) file descriptions being stored in each database application.
@1 @1 @1 @1 @1 @1 @1
B) data descriptions being stored on a server.
@1 @1 @1 @1 @1 @1
C) data descriptions being written into programming code.
@1 @1 @1 @1 @1 @1
D) data cohabiting with program
@1 @1 @1
s. Answer: A
@1 @1
LO: 1.2: Name several limitations of conventional file processing syst
@ 1 @1 @1 @1 @1 @1 @1 @1 @1
ems. Difficulty: Moderate
@1 @1
Classification: Concept @ 1
AACSB: Information Technology @ 1 @1
6) Because applications are often developed independently in file processing systems:
@1 @1 @1 @1 @1 @1 @1 @1 @1
A) the data is always non-redundant.
@1 @1 @1 @1
B) unplanned duplicate data files are the rule rather than the exception.
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1
C) data can always be shared with others.
@1 @1 @1 @1 @1 @1
D) there is a large volume of file I
@1 @1 @1 @1 @1 @1 @1
/O. Answer: B
@1 @1
LO: 1.2: Name several limitations of conventional file processing syst
@ 1 @1 @1 @1 @1 @1 @1 @1 @1
ems. Difficulty: Moderate
@1 @1
Classification: Concept @ 1
AACSB: Information Technology @ 1 @1
7) Relational databases establish the relationships between entities by means of common
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1
fields included in a file called a(n):
@1 @1 @1 @1 @1 @1
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
@1 @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi @1 @1
cation: Concept @1
AACSB: Information Technology @ 1 @1
8) A(n)
is often developed by identifying a form or report that a user needs on a regular
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
1basis.
A) enterprise view @1
B) reporting document @1
C) user view @1
D) user snapsho @1
t Answer: C
@1 @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
, 9) A graphical system used to capture the nature and relationships among data is called a(
@1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1
n):
A) XML data model.
@1 @1
B) hypertext graphic. @1
C) relational database. @1
D) data model
@1
.
Answer: D @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi
@1 @1
cation: Concept
@1
AACSB: Information Technology
@ 1 @1
10) Data that describe the properties of other data are:
@1 @1 @1 @1 @1 @1 @1 @1
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
@1 @1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi
@1 @1
cation: Concept
@1
AACSB: Information Technology
@ 1 @1
11) Metatdata typically describes all of the following EXCEPT:
@1 @1 @1 @1 @1 @1 @1
A) data definitions.
@1
B) length.
C) allowable values. @1
D) location on dis @1 @1
k.
Answer: D @ 1
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
@ 1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @1 @
file processing.
1 @1
Difficulty: Moderate Classifi
@1 @1
cation: Concept
@1
AACSB: Information Technology
@ 1 @1
4
Copyright © 2019 Pearson Education, I
@1 @1 @1 @1 @1
nc.
