Copyright 2019 Pearson Education, Inc.

1 Copyright © 2019 Pearson Education, Inc.Modern Database Management, 13e (Hoffer) Chapter 1 The Database Environment and Development Process 1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored

more than:

• 1 terabyte of data.
• 3 gigabytes of data.

C)at least 100 petabytes of data.

• more than 7 billion exabytes of data.

Answer: D

LO: 1.1: Define key terms.

Difficulty: Easy

Classification: Concept

AACSB: Information Technology

2) Database management involves all of the following EXCEPT:

• collecting data.
• organizing data.
• design web pages.
• managing data.

Answer: C

LO: 1.1: Define key terms.

Difficulty: Easy

Classification: Concept

AACSB: Information Technology

3) A database is an organized collection of ________ related data.A)logically

• physicallyC) looselyD) badlyAnswer: ALO: 1.1: Define key terms.Difficulty: EasyClassification: ConceptAACSB: Information Technology

4) Legacy systems often contain data of ________ quality and are generally hosted on ________.

• poor; personal computers
• excellent; mainframes
• poor; mainframes
• excellent; workgroup computers

Answer: C

LO: 3.1: Define key terms.

Difficulty: Moderate

Classification: Concept

AACSB: Information Technology

Modern Database Management, 13e Jeff Hoffer, Ramesh Venkataraman, Heikki Topi (Test Bank All Chapters, 100% Original Verified, A+ Grade) 1 / 4

2 Copyright © 2019 Pearson Education, Inc.

5) Program-data dependence is caused by:

• file descriptions being stored in each database application.
• data descriptions being stored on a server.
• data descriptions being written into programming code.
• data cohabiting with programs.

Answer: A

LO: 1.2: Name several limitations of conventional file processing systems.

Difficulty: Moderate

Classification: Concept

AACSB: Information Technology

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

• the data is always non-redundant.
• unplanned duplicate data files are the rule rather than the exception.
• data can always be shared with others.
• there is a large volume of file I/O.

Answer: B

LO: 1.2: Name several limitations of conventional file processing systems.

Difficulty: Moderate

Classification: Concept

AACSB: Information Technology

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

included in a file called a(n):

• entity.
• relationship.
• relation.
• 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.

• enterprise view
• reporting document
• user view
• user snapshot

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 2 / 4

3 Copyright © 2019 Pearson Education, Inc.9) A graphical system used to capture the nature and relationships among data is called a(n):

• XML data model.
• hypertext graphic.
• relational database.
• data model.

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

10) Data that describe the properties of other data are:

• relationships.
• logical.
• physical.
• 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

11) Metatdata typically describes all of the following EXCEPT:

• data definitions.
• length.
• allowable values.
• location on disk.

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

• / 4

4 Copyright © 2019 Pearson Education, Inc.12) A person, place, object, event, or concept about which the organization wishes to maintain

data is called a(n):

• relationship.
• object.
• attribute.
• entity.

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

13) ________ are established between entities in a well-structured database so that the desired information can be retrieved.

• Entities
• Relationships
• Lines
• Ties

Answer: B

LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing.

Difficulty: Moderate

Classification: Concept

AACSB: Information Technology

14) All of the following are primary purposes of a database management system (DBMS)

EXCEPT:

• creating data.
• updating data.
• storing data.
• providing an integrated development environment.

Answer: D

LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing.

Difficulty: Difficult

Classification: Concept

AACSB: Information Technology

• / 4