Chapter 5 Data and Knowledge Management Complete Test Bank

Package Title: Practice Questions

Course Title: Rainer, Introduction to Information Systems, Fifth Canadian Edition

Chapter Number: 05

Shuffle: No

Question Type: Multiple Choice

1) Which of the following problems does the information age pose for organizations?

a) Collecting the vast amounts of data that are being generated.

b) Storing the data that are being collected.

c) Processing and analyzing the data that are being stored.

d) all of the above

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Section Reference 1: Managing Data

2) The term "data rot" refers to

a) data that no longer serve a purpose.

b) the deterioration of the medium on which the data are stored.

c) data that are irrelevant or contain errors.

d) all of the above

Difficulty: Medium

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Section Reference 1: Managing Data

3) Data redundancy refers to

a) storing data in a single central location.

b) sharing data with others.

c) having copies of the same data in multiple locations.

d) all of the above

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question Type: True/False

4) In Canada, federal law requires public companies to evaluate and disclose the effectiveness of their internal financial controls, and the law also holds CEOs and CFOs personally liable for such disclosures.

Difficulty: Easy

'Bloomcode: Comprehension

AACSB Code: Ethics

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Section Reference 1: Managing Data

Question Type: Multiple Choice

5) The management of data across the entire organization is most accurately defined as

a) data integration.

b) data control.

c) data governance.

d) data administration.

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Section Reference 1: Managing Data

Question Type: Multiple Selection

6) The use of databases enables organizations to (choose all that apply):

a) minimize data redundancy.

b) minimize data isolation.

c) minimize data inconsistency.

d) minimize data security risks.

e) eliminate data integrity.

Answer 1: b

Answer 2: c

Answer 3: a

Difficulty: Hard

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question Type: True/False

7) A database must be associated with only one computer program or information system.

Difficulty: Medium

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

8) A group of related fields is generally called a data file.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question Type: Multiple Choice

9) A data model is the diagrammatic representation of a database that clearly defines a 'database's ____, ____, and ____.

a) entities; attributes; relationships

b) entity classes; hierarchy; files

c) data hierarchy; data attributes; data files

d) entity classes; entity attributes; entity files

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

10) A standardized language used to manipulate data is _____.

a) MS-Access

b) Oracle

c) Query-by-example (QBE)

d) none of the above

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

Question Type: True/False

11) A relational database typically consists of one large two-dimensional table.

Difficulty: Easy

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question Type: Multiple Choice

12) _____ is a method for analyzing and reducing a relational database to its most streamlined form.

a) Structured query

b) Normalization

c) Query-by-example

d) Relational analysis

Difficulty: Easy

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

Question Type: True/False

13) The data dictionary stores definitions of data elements, characteristics that use the data elements, and the individuals, business functions, applications, and reports that use these elements.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

14) A data warehouse is a low-cost, scaled-down version of a data mart designed for the end-user needs in a department of a large organization.

Difficulty: Easy

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Section Reference 1: Data Warehouses and Data Marts

Question Type: Multiple Choice

15) Operational data that are constantly updated are stored in

a) data warehouses.

b) data marts.

c) databases.

d) all of the above

Difficulty: Easy

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Section Reference 1: Data Warehouses and Data Marts

Question Type: True/False

16) Online analytical processing involves the analysis of accumulated data by end-users.

Difficulty: Easy

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Section Reference 1: Data Warehouses and Data Marts

Question Type: Multiple Choice

17) ____ is the cumulative store of subjective or experiential learning.

a) Tacit knowledge

b) Explicit knowledge

c) Intellectual capital

d) none of the above

Difficulty: Easy

'Bloomcode: Application

AACSB Code: Technology

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Section Reference 1: Knowledge Management

Question Type: True/False

18) Knowledge management systems (KMS) are used by organizations to capture, store, and disseminate knowledge within the organization.

Difficulty: Easy

'Bloomcode: Application

AACSB Code: Technology

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Section Reference 1: Knowledge Management

Question Type: Multiple Choice

19) _____ is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that is part of the 'organization's memory, and typically resides inside the organization in an unstructured manner.

a) Discovery

b) Knowledge management

c) Decision support

d) Data mining

Difficulty: Easy

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Section Reference 1: Knowledge Management

Question type: True/False

20) The amount of data increases exponentially over time.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Section Reference 1: Managing Data

Question type: Multiple-Choice

21) It is very difficult to manage data for which of the following reasons?

a) The amount of data stays about the same over time.

b) Data are scattered throughout organizations.

c) The decreasing amount of external data needs to be considered.

d) Data security is easy to maintain.

e) Data are stored in the same format throughout organizations.

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Section Reference 1: Managing Data

22) When customers access a Web site and make purchases, they generate _____.

a) tracking cookies

b) information

c) clickstream data

d) Web data

e) hyperlink data

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Section Reference 1: Managing Data

Question type: True/False

23) The primary key is a field that uniquely and completely identifies a record.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question type: Multiple-Choice

24) In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n)

a) attribute.

b) entity.

c) primary key.

d) object.

e) relation.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question type: True/False

25) When various copies of the data agree, this is an example of data integrity.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question type: Multiple-Choice

26) Place the following members of the data hierarchy in the correct order:

a) bit – byte – field – record – database – file

b) bit – field – byte – record – file – database

c) byte – bit – record – field – database

d) bit – byte – field – record – file – database

e) bit – record – field – byte – file – database

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

27) A _____ is a logical grouping of related fields.

a) byte

b) field

c) record

d) file

e) database

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

28) In a database, the primary key field is used to _____.

a) specify an entity

b) create linked lists

c) identify duplicated data

d) uniquely identify a record

e) uniquely identify an attribute

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Comprehension

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Section Reference 1: The Database Approach

Question type: True/False

29) Normalization is a method for eliminating redundant data elements.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

30) The data dictionary defines the format necessary to enter data into a database.

Difficulty: Medium

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

Question type: Multiple-Choice

31) Data dictionaries perform all of the following functions except

a) providing information on each record.

b) providing information on why attributes are needed in the database.

c) defining the format necessary to enter data into the database.

d) providing information on the name of attributes.

e) providing information on how often attributes should be updated.

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

32) A standardized language used to manipulate data is _____.

a) MS-Access

b) Oracle

c) Query-by-example language (QBE)

d) Structured query language (SQL)

e) Data manipulation language

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

33) _____ is a method for analyzing and reducing a relational database to its most streamlined form.

a) Structured query

b) Normalization

c) Query-by-example

d) Joining

e) Relational analysis

Difficulty: Medium

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modelling, and normalization and joins.

Section Reference 1: Appendix: Fundamentals of Relational Database Operations

Question type: True/False

34) Transferring data from the organization's operational databases into its data warehouse is called data reconciliation.

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Section Reference 1: Data Warehouses and Data Marts

Question type: Multiple-Choice

35) The data in a data warehouse have which of the following characteristics?

a) They are organized by subject.

b) They are coded in different formats.

c) They are updated in real-time.

d) They are typically retained for a defined but limited period of time.

e) They are organized in a hierarchical structure.

Difficulty: Medium

Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Section Reference 1: Data Warehouses and Data Marts

36) Compared to data warehouses, data marts have which one of the following characteristics?

a) cost less

b) have a longer lead time for implementation

c) have central rather than local control

d) contain more information

e) are harder to navigate

Difficulty: Medium

'Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Section Reference 1: Data Warehouses and Data Marts

37) Which of the following is an example of explicit knowledge?

a) experiences

b) insights

c) procedural guides

d) expertise

e) skill sets

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Section Reference 1: Knowledge Management

38) Explicit knowledge has which of the following characteristics?

a) objective

b) personal

c) slow

d) costly to transfer

e) ambiguous

Difficulty: Easy

'Bloomcode: Knowledge

AACSB Code: Technology

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Section Reference 1: Knowledge Management

39) The most important benefit of knowledge management systems is

a) improved customer service.

b) that they make the best practices available to employees.

c) the retention of scarce knowledge if employees retire.

d) improved morale.

e) more efficient product development.

Difficulty: Medium

Bloomcode: Comprehension

AACSB Code: Technology

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Section Reference 1: Knowledge Management