TESTBANK
v6
,Modern Database Management, 13e (Hoffer)
v6 v6 v6 v6
Chapter 1 The Database Environment and Development Process
v6 v 6 v6 v6 v6 v6 v6
1) According to a McKinsey Global InstituteReport, in2010 alone, globalenterprises stored
v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
more than:
v6 v6
A) 1 terabyte of data.
v6 v6 v6
B) 3 gigabytes of data.
v6 v6 v6
C) at least 100 petabytes of data.
v6 v6 v6 v6 v6
D) morethan 7 billion exabytesof data.
v6 v6 v6 v6 v6 v6
Answer: D
v6 v6
LO: 1.1:Define key terms.
v6 v6 v6 v6
Difficulty: Easy
v6 v6
Classification: Concept
v6 v 6
AACSB: Information Technology v 6 v6
2) Database management involves all of the following EXCEPT: v6 v6 v6 v6 v6 v6 v6
A) collecting data. v6
B) organizing data. v6
C) design web pages. v6 v6
D) managing data. v6
Answer: C
v6 v6
LO: 1.1:Define key terms.
v6 v6 v6 v6
Difficulty: Easy
v6 v6
Classification: Concept
v6 v 6
AACSB: Information Technology v 6 v6
3) Adatabase is an organized collection of
v6 v6 v6 v6 v6 v6 related data. v6
A) logically
B) physically
C) loosely
D) badly
Answer: A
v6 v6
LO: 1.1:Define key terms.
v6 v6 v6 v6
Difficulty: Easy
v6 v6
Classification: Concept
v6 v 6
AACSB: Information Technology v 6 v6
4) Legacy systems often contain data of v6 v6 v6 v6 v6 quality and are generally hosted on
v6 v6 v6 v6 v6 .
A) poor; personal computers
v6 v6
B) excellent; mainframes v6
C) poor; mainframes v6
D) excellent; workgroup computers v6 v6
Answer: C
v6 v6
LO: 3.1: Define key terms.
v6 v6 v6 v6
,5) Program-data dependence is caused by: v6 v6 v6 v6
A) file descriptions being stored in each database application.
v6 v6 v6 v6 v6 v6 v6
B) data descriptions being stored on a server.
v6 v6 v6 v6 v6 v6
C) datadescriptions being written into programming code.
v6 v6 v6 v6 v6 v6
D) data cohabiting with programs.
v6 v6 v6
Answer: A
v6 v6
LO: 1.2:Name severallimitations ofconventional file processing systems.
v 6 v6 v6 v6 v6 v6 v6 v6 v6
Difficulty: Moderate
v6 v6
Classification: Concept v 6
AACSB: Information Technology v 6 v6
6) Because applications are often developed independently in file processing systems:
v6 v6 v6 v6 v6 v6 v6 v6 v6
A) the data is always non-redundant.
v6 v6 v6 v6
B) unplanned duplicate data files are the rule rather than the exception. v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
C) data can always be shared with others.
v6 v6 v6 v6 v6 v6
D) thereisa large volumeof file I/O.
v6 v6 v6 v6 v6 v6 v6
Answer: B
v6 v6
LO: 1.2:Name severallimitations of conventional file processing systems.
v 6 v6 v6 v6 v6 v6 v6 v6 v6
Difficulty: Moderate
v6 v6
Classification: Concept v 6
AACSB: Information Technology v 6 v6
7) Relationaldatabasesestablish the relationships between entities by means ofcommon fields
v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
included in a file called a(n):
v6 v6 v6 v6 v6 v6
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology v 6 v6
8) A(n) is often developed by identifying a form or report that a user needs on a v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
regular basis.
v6 v6
A) enterprise view v6
B) reportingdocument v6
C) user view v6
D) user snapshot v6
Answer: C
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
, 9) Agraphical system used to capture the nature and relationships among data is called a(n):
v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
A) XML data model.
v6 v6
B) hypertext graphic. v6
C) relationaldatabase. v6
D) data model.
v6
Answer: D
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology
v 6 v6
10) Datathat describe the properties of other data are:
v6 v6 v6 v6 v6 v6 v6 v6
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology
v 6 v6
11) Metatdata typically describes all of the following EXCEPT:
v6 v6 v6 v6 v6 v6 v6
A) data definitions.
v6
B) length.
C) allowable values. v6
D) location on disk. v6 v6
Answer: D
v6 v 6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology
v 6 v6
.
v6
,Modern Database Management, 13e (Hoffer)
v6 v6 v6 v6
Chapter 1 The Database Environment and Development Process
v6 v 6 v6 v6 v6 v6 v6
1) According to a McKinsey Global InstituteReport, in2010 alone, globalenterprises stored
v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
more than:
v6 v6
A) 1 terabyte of data.
v6 v6 v6
B) 3 gigabytes of data.
v6 v6 v6
C) at least 100 petabytes of data.
v6 v6 v6 v6 v6
D) morethan 7 billion exabytesof data.
v6 v6 v6 v6 v6 v6
Answer: D
v6 v6
LO: 1.1:Define key terms.
v6 v6 v6 v6
Difficulty: Easy
v6 v6
Classification: Concept
v6 v 6
AACSB: Information Technology v 6 v6
2) Database management involves all of the following EXCEPT: v6 v6 v6 v6 v6 v6 v6
A) collecting data. v6
B) organizing data. v6
C) design web pages. v6 v6
D) managing data. v6
Answer: C
v6 v6
LO: 1.1:Define key terms.
v6 v6 v6 v6
Difficulty: Easy
v6 v6
Classification: Concept
v6 v 6
AACSB: Information Technology v 6 v6
3) Adatabase is an organized collection of
v6 v6 v6 v6 v6 v6 related data. v6
A) logically
B) physically
C) loosely
D) badly
Answer: A
v6 v6
LO: 1.1:Define key terms.
v6 v6 v6 v6
Difficulty: Easy
v6 v6
Classification: Concept
v6 v 6
AACSB: Information Technology v 6 v6
4) Legacy systems often contain data of v6 v6 v6 v6 v6 quality and are generally hosted on
v6 v6 v6 v6 v6 .
A) poor; personal computers
v6 v6
B) excellent; mainframes v6
C) poor; mainframes v6
D) excellent; workgroup computers v6 v6
Answer: C
v6 v6
LO: 3.1: Define key terms.
v6 v6 v6 v6
,5) Program-data dependence is caused by: v6 v6 v6 v6
A) file descriptions being stored in each database application.
v6 v6 v6 v6 v6 v6 v6
B) data descriptions being stored on a server.
v6 v6 v6 v6 v6 v6
C) datadescriptions being written into programming code.
v6 v6 v6 v6 v6 v6
D) data cohabiting with programs.
v6 v6 v6
Answer: A
v6 v6
LO: 1.2:Name severallimitations ofconventional file processing systems.
v 6 v6 v6 v6 v6 v6 v6 v6 v6
Difficulty: Moderate
v6 v6
Classification: Concept v 6
AACSB: Information Technology v 6 v6
6) Because applications are often developed independently in file processing systems:
v6 v6 v6 v6 v6 v6 v6 v6 v6
A) the data is always non-redundant.
v6 v6 v6 v6
B) unplanned duplicate data files are the rule rather than the exception. v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
C) data can always be shared with others.
v6 v6 v6 v6 v6 v6
D) thereisa large volumeof file I/O.
v6 v6 v6 v6 v6 v6 v6
Answer: B
v6 v6
LO: 1.2:Name severallimitations of conventional file processing systems.
v 6 v6 v6 v6 v6 v6 v6 v6 v6
Difficulty: Moderate
v6 v6
Classification: Concept v 6
AACSB: Information Technology v 6 v6
7) Relationaldatabasesestablish the relationships between entities by means ofcommon fields
v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
included in a file called a(n):
v6 v6 v6 v6 v6 v6
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology v 6 v6
8) A(n) is often developed by identifying a form or report that a user needs on a v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
regular basis.
v6 v6
A) enterprise view v6
B) reportingdocument v6
C) user view v6
D) user snapshot v6
Answer: C
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
, 9) Agraphical system used to capture the nature and relationships among data is called a(n):
v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
A) XML data model.
v6 v6
B) hypertext graphic. v6
C) relationaldatabase. v6
D) data model.
v6
Answer: D
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology
v 6 v6
10) Datathat describe the properties of other data are:
v6 v6 v6 v6 v6 v6 v6 v6
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
v6 v6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology
v 6 v6
11) Metatdata typically describes all of the following EXCEPT:
v6 v6 v6 v6 v6 v6 v6
A) data definitions.
v6
B) length.
C) allowable values. v6
D) location on disk. v6 v6
Answer: D
v6 v 6
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
v 6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6 v6
processing.
v6
Difficulty: Moderate v6
Classification: Concept
v6 v6
AACSB: Information Technology
v 6 v6
.
