Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
The environmental element that is not provided information by the transaction processing system
is the:
1)
A)
customer.
B)
stockholder.
C)
supplier.
D)
competitor.
2)
Which subsystem of the marketing mix provides information about the firm’s distribution
network?
2)
A)
promotion subsystem
B)
distribution subsystem
C)
place subsystem
D)
integrated-mix subsystem
3)
The subsystem of the marketing mix that provides information about the firm’s advertising and
personal selling activities is the:
3)
A)
product subsystem.
B)
integrated-mix subsystem.
C)
advertising subsystem.
D)
promotion subsystem.
4)
Which activity is not part of the information delivery system in a data warehousing system?
4)
A)
Obtain data from the data repository.
B)
Enter data.
C)
Transform data into information.
D)
Make information available to users.
5)
Which system is not a major subsystem of the distribution system?
5)
A)
hire new employees
B)
order replenishment stock
C)
maintain general ledger
D)
fill orders
6)
The foundation of the transaction processing system is the:
6)
A)
information.
B)
processes.
C)
database.
D)
general ledger system.
7)
The process of finding relationships in data that are unknown to the user is:
7)
A)
data warehousing.
B)
data marting.
C)
data searching.
D)
data mining.
8)
Which subsystem of a human resources information system is not an output subsystem?
8)
A)
compensation subsystem
B)
research subsystem
C)
work force planning subsystem
D)
recruiting subsystem
9)
The output subsystems of a Marketing Information System include all of the following except for:
9)
A)
integrated-mix subsystem.
B)
balanced subsystem.
C)
place subsystem.
D)
product subsystem.
10)
Which of the following is not an input subsystem of a human resources information system?
10)
A)
intelligence subsystem
B)
research subsystem
C)
recruiting subsystem
D)
transaction processing system
11)
The process of quickly moving from one data hierarchy to another when navigating a data
warehouse is called:
11)
A)
drill across.
B)
drill through.
C)
drill down.
D)
roll up.
12)
Which subsystem is the fifth ingredient of the marketing mix?
12)
A)
promotion subsystem
B)
integrated-mix subsystem
C)
place subsystem
D)
product subsystem
13)
Which of the following is not a characteristic of data warehouses?
13)
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.
14)
A database that contains data describing only a segment of the firm’s operations is called a:
14)
A)
data mart.
B)
data warehouse.
C)
data mine.
D)
business area database.
15)
In a sample star schema, which table would be the fact table?
15)
A)
customer
B)
time
C)
product sales
D)
salesperson
16)
The information system that provides information to upper-level managers on the overall
performance of the firm is referred to as a(n):
16)
A)
management information system.
B)
executive information system.
C)
marketing information system.
D)
human resources information system.
17)
The business area that has the strongest need for historical data is the:
17)
A)
information resources area.
B)
human resources area.
C)
marketing area.
D)
finance area.
18)
The system that analyzes the warehouse data repository looking for groups with common
characteristics is referred to as:
18)
A)
data mining.
B)
data warehousing.
C)
knowledge discovery.
D)
knowledge management.
19)
The DFD that presents the system in the context of its environment is called a:
19)
A)
context diagram.
B)
leveled DFD.
C)
figure 0 diagram.
D)
balanced DFD.
20)
The newest name for a transaction processing system is:
20)
A)
distribution system.
B)
electronic data processing.
C)
general ledger system.
D)
accounting information system.
21)
Which of the following is not a subsystem of the order replenishment stock system?
21)
A)
accounts payable system
B)
inventory system
C)
purchasing system
D)
receiving system
22)
The information system that is intended for an organizational level rather than a business area is
the:
22)
A)
executive information system.
B)
human resources information system.
C)
finance information system.
D)
information services information system.
23)
The data flows from the distribution system to management consist of all of the following except
for:
23)
A)
a balance sheet.
B)
invoices.
C)
an income statement.
D)
budget reports.
24)
Which type of table in the warehouse data repository stores quantitative measures of an entity,
object, or activity?
24)
A)
flat table
B)
truth table
C)
fact table
D)
dimension table
25)
The input subsystem in the marketing information system that gathers environmental data to keep
management informed of the firm’s competitors is the:
25)
A)
research and development subsystem.
B)
marketing research subsystem.
C)
data gathering subsystem.
D)
marketing intelligence subsystem.
26)
The process of entering data into the warehouse data repository is referred to as:
26)
A)
data entry.
B)
extraction.
C)
transformation.
D)
loading.
27)
Which of the following is not a subsystem of the fills customer orders system?
27)
A)
accounts payable system
B)
order entry system
C)
accounts receivable system
D)
inventory system
28)
One processing approach that is common in executive information systems is called:
28)
A)
drill through.
B)
drill down.
C)
drill across.
D)
drill up.
29)
The type of processing that produces summaries at various levels of detail and arranges the data by
various dimensions is called:
29)
A)
DOLAP.
B)
ROLAP.
C)
MOLAP.
D)
OLAP.
30)
Which statement is false concerning transaction processing systems?
30)
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.
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
31)
The ________ process combines data from the various sources.
31)
32)
An ________ system enters customer orders into the system.
32)
33)
The ________ system is a system that provides information to upper-level managers on the
overall performance of the firm.
33)
34)
________ contain quantitative measures of an entity, object, or activity.
34)
35)
The ________ process cleans the data, puts it into a standardized format, and prepares
summaries.
35)
36)
The few key activities of an organization are known as the organization’s ________.
36)
37)
M The term ________ means “data about data.”
37)
38)
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.
38)
39)
The ________ process involves the entry of the data into the warehouse data repository.
39)
40)
The ________ mix consists of four main ingredients that management manages in order to
meet customers’ needs at a profit.
40)
41)
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.
41)
42)
An ________ identifies all of the dimensions that will be used in analyzing a particular
activity.
42)
43)
The ________ provides information about the firm’s distribution network.
43)
44)
The ________ system provides information to managers throughout the firm concerning
the firm’s human resources.
44)
45)
A ________ is a database that contains data describing only a segment of the firm’s
operations.
45)
TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
46)
The data flows from the distribution system to suppliers consist of purchase orders only.
46)
47)
MOLAP utilizes a special multidimensional database management system.
47)
48)
In the marketing mix, the advertising subsystem provides information about the firm’s advertising
and personal selling activities.
48)
49)
A data store in a DFD represents relatively permanent storage of data such as a master file or a
history file.
49)
50)
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.
50)
51)
A data mart is a database that contains data describing only a segment of the firm’s operations.
51)
52)
An example of a transaction processing system is a distribution system.
52)
53)
All organizations are in the distribution business in one form or another.
53)
54)
Dimension tables and truth tables are combined to form an introduction package.
54)
55)
A context diagram presents the system in the context of its environment.
55)
56)
In the warehouse data repository, two types of data are stored in the same table.
56)
57)
The transaction processing system has a responsibility to furnish information on each
environmental element.
57)
58)
In knowledge management, the system analyzes the warehouse data repository, looking for groups
with common characteristics.
58)
59)
The primary data sources of a data warehouse are the firm’s transaction processing systems only.
59)
60)
When each dimension in a dimension table is linked to a fact table, it is called a star schema.
60)
61)
The human resources information system provides information to managers throughout the firm
concerning the firm’s human resources.
61)
62)
The extraction process of ETL combines data from various sources.
62)
63)
ROLAP has a faster summary ability than MOLAP and can produce information in more than 10
dimensions.
63)
64)
OLAP refers to online application processing.
64)
65)
The central element in a CRM system is the transaction processing database.
65)
66)
Data mining is the process of finding relationships in data that are unknown to the user.
66)
67)
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.
67)
68)
An advantage of hypothesis verification is that the user guides the entire retrieval process.
68)
69)
Data flows in a DFD reflect only physical resources.
69)
70)
Dimension tables in a warehouse data repository store identifying and descriptive data.
70)
71)
The final element in the data warehousing system is the information delivery system.
71)
72)
The process of drilling through the data in a data warehouse originated with executive information
systems.
72)
73)
ROLAP can easily produce outputs at detailed levels and at a few summary levels.
73)
74)
The foundation of a transaction processing system is in its database.
74)
75)
The transaction processing system gathers data from both internal and environmental sources and
enters the data into the database.
75)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
76)
Describe what happens to data as it goes through the staging area in a data warehouse.
77)
What are the major systems and the subsystems of a distribution system?
78)
Explain the relationship between OLAP, ROLAP, and MOLAP.
79)
Define customer relationship management and the CRM system.
80)
Define knowledge discovery and explain its contribution to data warehousing.
