Deck 8: Information in Action

Question 1

A database that contains data describing only a segment of the firm's operations is called a:

A)data mart.
B)data warehouse.
C)data mine.
D)business area database.

Answer 1

A

Question 2

Which activity is not part of the information delivery system in a data warehousing system?

A)Obtain data from the data repository.
B)Enter data.
C)Transform data into information.
D)Make information available to users.

Answer 2

B

Question 3

Which subsystem of a human resources information system is not an output subsystem?

A)compensation subsystem
B)research subsystem
C)work force planning subsystem
D)recruiting subsystem

Answer 3

B

Question 4

The information system that provides information to upper- level managers on the overall performance of the firm is referred to as a(n):

A)management information system.
B)executive information system.
C)marketing information system.
D)human resources information system.

Question 5

The process of finding relationships in data that are unknown to the user is:

A)data warehousing.
B)data marting.
C)data searching.
D)data mining.

Question 6

Which subsystem of the marketing mix provides information about the firm's distribution network?

A)promotion subsystem
B)distribution subsystem
C)place subsystem
D)integrated- mix subsystem

Question 7

The output subsystems of a Marketing Information System include all of the following except for:

A)integrated- mix subsystem.
B)balanced subsystem.
C)place subsystem.
D)product subsystem.

Question 8

Which system is not a major subsystem of the distribution system?

A)hire new employees
B)order replenishment stock
C)maintain general ledger
D)fill orders

Question 9

The system that analyzes the warehouse data repository looking for groups with common characteristics is referred to as:

A)data mining.
B)data warehousing.
C)knowledge discovery.
D)knowledge management.

Question 10

The environmental element that is not provided information by the transaction processing system is the:

A)customer.
B)stockholder.
C)supplier.
D)competitor.

Question 11

In a sample star schema, which table would be the fact table?

A)customer
B)time
C)product sales
D)salesperson

Question 12

The business area that has the strongest need for historical data is the:

A)information resources area.
B)human resources area.
C)marketing area.
D)finance area.

Question 13

The DFD that presents the system in the context of its environment is called a:

A)context diagram.
B)leveled DFD.
C)figure 0 diagram.
D)balanced DFD.

Question 14

The process of quickly moving from one data hierarchy to another when navigating a data warehouse is called:

A)drill across.
B)drill through.
C)drill down.
D)roll up.

Question 15

Which of the following is not an input subsystem of a human resources information system?

A)intelligence subsystem
B)research subsystem
C)recruiting subsystem
D)transaction processing system

Question 16

The foundation of the transaction processing system is the:

A)information.
B)processes.
C)database.
D)general ledger system.

Question 17

Which subsystem is the fifth ingredient of the marketing mix?

A)promotion subsystem
B)integrated- mix subsystem
C)place subsystem
D)product subsystem

Question 18

The newest name for a transaction processing system is:

A)distribution system.
B)electronic data processing.
C)general ledger system.
D)accounting information system.

Question 19

The subsystem of the marketing mix that provides information about the firm's advertising and personal selling activities is the:

A)product subsystem.
B)integrated- mix subsystem.
C)advertising subsystem.
D)promotion subsystem.

Question 20

Which of the following is not a characteristic of data warehouses?

A)The data is very easily retrievable.
B)The data describes only a segment of the firm's operations.
C)The data is used solely for decision making.
D)The storage capacity is very large scale.

Question 21

The information system that is intended for an organizational level rather than a business area is the:

A)executive information system.
B)human resources information system.
C)finance information system.
D)information services information system.

Question 22

The process involves the entry of the data into the warehouse data repository.

Question 23

Which of the following is not a subsystem of the fills customer orders system?

A)accounts payable system
B)order entry system
C)accounts receivable system
D)inventory system

Question 24

The data flows from the distribution system to management consist of all of the following except for:

A)a balance sheet.
B)invoices.
C)an income statement.
D)budget reports.

Question 25

The process of entering data into the warehouse data repository is referred to as:

A)data entry.
B)extraction.
C)transformation.
D)loading.

Question 26

The system is a system that provides information to upper- level managers on the overall performance of the firm.

Question 27

An system enters customer orders into the system.

Question 28

The mix consists of four main ingredients that management manages in order to meet customers' needs at a profit.

Question 29

Which type of table in the warehouse data repository stores quantitative measures of an entity, object, or activity?

A)flat table
B)truth table
C)fact table
D)dimension table

Question 30

M The term means "data about data."

Question 31

The input subsystem in the marketing information system that gathers environmental data to keep management informed of the firm's competitors is the:

A)research and development subsystem.
B)marketing research subsystem.
C)data gathering subsystem.
D)marketing intelligence subsystem.

Question 32

The type of processing that produces summaries at various levels of detail and arranges the data by various dimensions is called:

A)DOLAP.
B)ROLAP.
C)MOLAP.
D)OLAP.

Question 33

The few key activities of an organization are known as the organization's .

Question 34

Which statement is false concerning transaction processing systems?

A)The system was the first computerized business application to be installed in the 1960s.
B)The system makes the information available to users inside and outside the firm.
C)The system gathers data describing the firm's activities.
D)The system transforms data into information.

Question 35

The system is the accounting system that combines data from other accounting systems for the purpose of presenting a composite financial picture of the firm's operations.

Question 36

One processing approach that is common in executive information systems is called:

A)drill through.
B)drill down.
C)drill across.
D)drill up.

Question 37

The process combines data from the various sources.

Question 38

contain quantitative measures of an entity, object, or activity.

Question 39

The process cleans the data, puts it into a standardized format, and prepares summaries.

Question 40

Which of the following is not a subsystem of the order replenishment stock system?

A)accounts payable system
B)inventory system
C)purchasing system
D)receiving system

Question 41

An executive information system has the drill across ability so the user can bring up a summary display and then successively display lower levels of detail.

Question 42

In the marketing mix, the advertising subsystem provides information about the firm's advertising and personal selling activities.

Question 43

MOLAP utilizes a special multidimensional database management system.

Question 44

Dimension tables and truth tables are combined to form an introduction package.

Question 45

The transaction processing system has a responsibility to furnish information on each environmental element.

Question 46

A data store in a DFD represents relatively permanent storage of data such as a master file or a history file.

Question 47

An identifies all of the dimensions that will be used in analyzing a particular activity.

Question 48

A data mart is a database that contains data describing only a segment of the firm's operations.

Question 49

The provides information about the firm's distribution network.

Question 50

A _ is a database that contains data describing only a segment of the firm's operations.

Question 51

In knowledge management, the system analyzes the warehouse data repository, looking for groups with common characteristics.

Question 52

When each dimension in a dimension table is linked to a fact table, it is called a star schema.

Question 53

An example of a transaction processing system is a distribution system.

Question 54

All organizations are in the distribution business in one form or another.

Question 55

The system provides information to managers throughout the firm concerning the firm's human resources.

Question 56

The data flows from the distribution system to suppliers consist of purchase orders only.

Question 57

The term system is used to describe the information system that gathers data describing the firm's activities, transforms the data into information, and makes the information available to users both inside and outside the firm.

Question 58

A context diagram presents the system in the context of its environment.

Question 59

The primary data sources of a data warehouse are the firm's transaction processing systems only.

Question 60

In the warehouse data repository, two types of data are stored in the same table.

Question 61

The foundation of a transaction processing system is in its database.

Question 62

ROLAP has a faster summary ability than MOLAP and can produce information in more than 10 dimensions.

Question 63

The transaction processing system gathers data from both internal and environmental sources and enters the data into the database.

Question 64

Describe what happens to data as it goes through the staging area in a data warehouse.

Question 65

Define knowledge discovery and explain its contribution to data warehousing.

Question 66

The central element in a CRM system is the transaction processing database.

Question 67

The final element in the data warehousing system is the information delivery system.

Question 68

Explain the relationship between OLAP, ROLAP, and MOLAP.

Question 69

The human resources information system provides information to managers throughout the firm concerning the firm's human resources.

Question 70

Define customer relationship management and the CRM system.

Question 71

Dimension tables in a warehouse data repository store identifying and descriptive data.

Question 72

ROLAP can easily produce outputs at detailed levels and at a few summary levels.

Question 73

What are the major systems and the subsystems of a distribution system?

Question 74

An advantage of hypothesis verification is that the user guides the entire retrieval process.

Question 75

Data mining is the process of finding relationships in data that are unknown to the user.

Question 76

The process of drilling through the data in a data warehouse originated with executive information systems.

Question 77

OLAP refers to online application processing.

Question 78

The contribution of knowledge discovery is the fact that it gives the data warehousing system an ability to analyze data that exceeds that of the users.

Question 79

The extraction process of ETL combines data from various sources.

Question 80

Data flows in a DFD reflect only physical resources.