Question 1

The biggest problem today is gathering data and then using it properly.

Accepted Answer

A) True 
 B)False

Question 2

Data ___________ ensures data meets system constraints.

Accepted Answer

A) Consistency 
B) Independence 
C) Integrity 
D) Security 
A) Consistency 
B) Independence 
C) Integrity 
D) Security

Question 3

Data rot refers to the quality of the data itself.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following statements is TRUE?

Accepted Answer

A) Databases are organized to make queries very easy. 
B) Running queries in a data warehouse does not degrade database performance. 
C) Databases are well-suited for making comparisons between records. 
D) Querying databases is the most effective and efficient way of using data. 
A) Databases are organized to make queries very easy. 
B) Running queries in a data warehouse does not degrade database performance. 
C) Databases are well-suited for making comparisons between records. 
D) Querying databases is the most effective and efficient way of using data.

Question 5

As an individual student in your university's student database, you are a(n)_____ of the STUDENT class.

Accepted Answer

A) Instance 
B) Individual 
C) Representative 
D) Entity 
E) Relationship 
A) Instance 
B) Individual 
C) Representative 
D) Entity 
E) Relationship

Question 6

The data in a data warehouse:

Accepted Answer

A) Are updated constantly in real time. 
B) Are updated in batch mode, approximately once per day. 
C) Are not updated. 
D) Are purged constantly as new data enter. 
E) Are available for MIS analysts, but not users. 
A) Are updated constantly in real time. 
B) Are updated in batch mode, approximately once per day. 
C) Are not updated. 
D) Are purged constantly as new data enter. 
E) Are available for MIS analysts, but not users.

Question 7

Knowledge is information in action.

Accepted Answer

A) True 
 B)False

Question 8

In data warehouses and data marts, data are stored in a multidimensional structure which is sometimes visually represented as a 3-dimensional data cube. Figure 5.7 is an example of a data cube of sales with the dimensions of product, geographic area, and time period (year). These are called business dimensions. What would the business dimensions be for Walmart's sales with its many sales transactions for many products in many stores that would allow them to do weekly analysis?

Accepted Answer

A) Customer, product, and month 
B) Customer, product, store 
C) Customer, product, store, and month 
D) Customer, product, store, and week 
E) Product, store, and week 
A) Customer, product, and month 
B) Customer, product, store 
C) Customer, product, store, and month 
D) Customer, product, store, and week 
E) Product, store, and week

Question 9

Which of the following has (have)the broadest impact on an organization?

Accepted Answer

A) Decisions about hardware. 
B) Decisions about software. 
C) Decisions about data. 
D) Both "decisions about hardware" and "decisions about software." 
E) All of these have an equal impact. 
A) Decisions about hardware. 
B) Decisions about software. 
C) Decisions about data. 
D) Both "decisions about hardware" and "decisions about software." 
E) All of these have an equal impact.

Question 10

A data mart can be implemented more quickly than a data warehouse.

Accepted Answer

A) True 
 B)False

Question 11

Managing the massive amounts of data that are critical to organizational success comes at a huge cost.

Accepted Answer

A) True 
 B)False

Question 12

Data marts are designed for the end-user needs in a strategic business unit or department.

Accepted Answer

A) True 
 B)False

Question 13

Describe the various multiple sources for data, and provide an example of each.

Accepted Answer

Multiple sources for data can include pr

Question 14

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry on the same order. Which of the following entity-relationships describes this situation?

Accepted Answer

A) The entities Customer and Order have a one to many relationship. 
B) The entities Customer and Order have a many to many relationship. 
C) The entities Customer and Jewelry Item have a one to many relationship. 
D) The entities Order and Jewelry Item have a one to many relationship. 
E) The entities Order and Jewelry Item have a many to many relationship. 
A) The entities Customer and Order have a one to many relationship. 
B) The entities Customer and Order have a many to many relationship. 
C) The entities Customer and Jewelry Item have a one to many relationship. 
D) The entities Order and Jewelry Item have a one to many relationship. 
E) The entities Order and Jewelry Item have a many to many relationship.

Question 15

In Canada, Bill 198 legally mandates that public companies evaluate and disclose the effectiveness of their ________________.

Accepted Answer

A) IT policies 
B) HR rules 
C) financial controls 
D) sales goals 
A) IT policies 
B) HR rules 
C) financial controls 
D) sales goals

Question 16

Describe entity-relationship modeling.

Accepted Answer

Entity-relationship modeling is a method

Question 17

_____________ reduces a relational database to its most streamlined form.

Accepted Answer

A) A data dictionary 
B) A database management system 
C) Normalization 
D) Streamlining 
A) A data dictionary 
B) A database management system 
C) Normalization 
D) Streamlining

Question 18

You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management?

Accepted Answer

A) Data redundancy 
B) Data inconsistency 
C) Data isolation 
D) Data security 
E) Data dependence 
A) Data redundancy 
B) Data inconsistency 
C) Data isolation 
D) Data security 
E) Data dependence

Question 19

_____ occurs when the same data are stored in many places.

Accepted Answer

A) Data isolation 
B) Data integrity 
C) Data consistency 
D) Data redundancy 
E) Application/Data dependence 
A) Data isolation 
B) Data integrity 
C) Data consistency 
D) Data redundancy 
E) Application/Data dependence

Question 20

Data dictionaries perform all of the following functions except:

Accepted Answer

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 each attribute. 
E) Providing information on how often attributes should be updated. 
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 each attribute. 
E) Providing information on how often attributes should be updated.

The biggest problem today is gathering data and then using it properly.

Data ___________ ensures data meets system constraints.

Data rot refers to the quality of the data itself.

Which of the following statements is TRUE?

As an individual student in your university's student database, you are a(n)_____ of the STUDENT class.

The data in a data warehouse:

Knowledge is information in action.

Which of the following has (have)the broadest impact on an organization?

A data mart can be implemented more quickly than a data warehouse.

Managing the massive amounts of data that are critical to organizational success comes at a huge cost.

Data marts are designed for the end-user needs in a strategic business unit or department.

Describe the various multiple sources for data, and provide an example of each.

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry on the same order. Which of the following entity-relationships describes this situation?

In Canada, Bill 198 legally mandates that public companies evaluate and disclose the effectiveness of their ________________.

Describe entity-relationship modeling.

_____________ reduces a relational database to its most streamlined form.

You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management?

_____ occurs when the same data are stored in many places.

Data dictionaries perform all of the following functions except:

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Ethics and Privacy

Information Security and Controls

Telecommunications and Networking

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Social Computing

Information Systems Within the Organization

Customer Relationship Management and Supply Chain Management

Business Intelligence

Acquiring Information Systems and Applications

Technology Guide 1 : Hardware

Technology Guide 2 : Software

Technology Guide 3 : Cloud Computing

Technology Guide 4 : Intelligent Systems

Technology Guide 5 Protecting Your Information Assets

Filters

Exam 5: Data and Knowledge Management

The biggest problem today is gathering data and then using it properly.

Data ___________ ensures data meets system constraints.

Data rot refers to the quality of the data itself.

Which of the following statements is TRUE?

As an individual student in your university's student database, you are a(n)_____ of the STUDENT class.

The data in a data warehouse:

Knowledge is information in action.

Which of the following has (have)the broadest impact on an organization?

A data mart can be implemented more quickly than a data warehouse.

Managing the massive amounts of data that are critical to organizational success comes at a huge cost.

Data marts are designed for the end-user needs in a strategic business unit or department.

Describe the various multiple sources for data, and provide an example of each.

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry on the same order. Which of the following entity-relationships describes this situation?

In Canada, Bill 198 legally mandates that public companies evaluate and disclose the effectiveness of their ________________.

Describe entity-relationship modeling.

_____________ reduces a relational database to its most streamlined form.

You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management?

_____ occurs when the same data are stored in many places.

Data dictionaries perform all of the following functions except:

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Ethics and Privacy

Information Security and Controls

Telecommunications and Networking

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Social Computing

Information Systems Within the Organization

Customer Relationship Management and Supply Chain Management

Business Intelligence

Acquiring Information Systems and Applications

Technology Guide 1 : Hardware

Technology Guide 2 : Software

Technology Guide 3 : Cloud Computing

Technology Guide 4 : Intelligent Systems

Technology Guide 5 Protecting Your Information Assets

Filters