Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
C) in-memory computing.
D) analytic platforms.
64) A nationwide magazine publisher has hired you to help analyze their social media datasets
to determine which of their news publications are seen as the most trustworthy. Which of
the following tools would you use to analyze this data?
A) text mining tools
B) sentiment analysis software
C) Web usage mining technologies
D) data mining software for identifying associations
65) The tool that enables users to view the same data in different ways using multiple
dimensions is
A) predictive analysis.
B) SQL.
C) OLAP.
D) data mining.
66) OLAP is a tool for enabling
A) users to obtain online answers to ad-hoc questions in a rapid amount of time.
B) users to view both logical and physical views of data.
C) programmers to quickly diagram data relationships.
D) programmers to normalize data.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
67) Data mining is a tool for allowing users to
A) quickly compare transaction data gathered over many years.
B) find hidden relationships in data.
C) obtain online answers to ad-hoc questions in a rapid amount of time.
D) summarize massive amounts of data into much smaller, traditional reports.
68) In terms of data relationships, associations refers to
A) events linked over time.
B) patterns that describe a group to which an item belongs.
C) occurrences linked to a single event.
D) undiscovered groupings.
69) ________ tools are used to analyze large unstructured data sets, such as e-mail, memos,
survey responses, etc., to discover patterns and relationships.
A) OLAP
B) Text mining
C) In-memory
D) Clustering
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
70) An alternative to using application server software for interfacing between a Web server
and back-end databases is
A) CGI.
B) HTML.
C) Java.
D) SQL.
71) The organization’s rules for sharing, disseminating, acquiring, standardizing, classifying,
and inventorying information is called a(n)
A) information policy.
B) data definition file.
C) data quality audit.
D) data governance policy.
72) The special organizational function whose responsibilities include physical database design
and maintenance, is called
A) data administration.
B) database administration.
C) information policy administration.
D) data auditing.
73) Which common database challenge is illustrated by a person receiving multiple copies of an
L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
A) data normalization
B) data accuracy
C) data redundancy
D) data inconsistency
74) Detecting and correcting data in a database or file that are incorrect, incomplete, improperly
formatted, or redundant is called
A) data auditing.
B) defragmentation.
C) data scrubbing.
D) data optimization.
75) You are creating a database to store temperature and wind data from national airport
locations. Which of the following fields is the most likely candidate to use as the basis for a
primary key in the Airport table?
A) address
B) city
C) airport code
D) state
76) Data cleansing not only corrects errors but also
A) establishes logical relationships between data.
B) structures data.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
C) normalizes data.
D) enforces consistency among different sets of data.
77) Which of the following is not a method for performing a data quality audit?
A) surveying entire data files
B) surveying samples from data files
C) surveying data definition and query files
D) surveying end users about their perceptions of data quality
78) The most popular type of DBMS today for PCs as well as for larger computers and
mainframes is the ____________________________.
A) relational DBMS
B) relational DMBS
C) rational DBMS
D) rational DMBS
79) A ________________________ is a database that stores current and historical data of
potential interest to decision makers throughout the company.
A) data warehouse
B) in-memory computing
C) analytic platforms
D) Data mining
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
80) Another way of facilitating big data analysis is to use _______________________, which
relies primarily on a computer’s main memory (RAM) for data storage.
A) data warehouse
B) in-memory computing
C) analytic platforms
D) Data mining
81) Commercial database vendors have developed specialized high-speed
________________________ using both relational and non-relational technology that are
optimized for analyzing large datasets.
A) data warehouse
B) in-memory computing
C) analytic platforms
D) Data mining
82) In__________________, events are linked over time.
A) Sequences,
B) Classification
C) Clustering
D) Forecasting
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
83) __________________________ recognizes patterns that describe the group to which an
item belongs by examining existing items that have been classified and by inferring a set of
rules.
A) Sequences,
B) Classification
C) Clustering
D) Forecasting
84) __________________________ works in a manner similar to classification when no groups
have yet been defined.
A) Sequences,
B) Classification
C) Clustering
D) Forecasting
85) ____________________ uses predictions in a different way. It uses a series of existing
values to predict what other values will be.
A) Sequences,
B) Classification
C) Clustering
D) Forecasting
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
86) The discovery and analysis of useful patterns and information from the World Wide Web is
called ______________________.
A) Data mining
B) Web surfing
C) Web data
D) Web mining
87) _________________________ used to describe many of these activities. Promoted by IBM,
data governance deals with the policies and processes for managing the availability, usability,
integrity, and security of the data employed in an enterprise, with special emphasis on
promoting privacy, security, data quality, and compliance with government regulations.
A) database administration
B) data cleansing
C) data security
D) data governance
88) Databases record information about general categories of information referred to as
________.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
89) To analyze unstructured data, such as memos and legal cases, you would use ________
tools.
90) A(n) ________ view shows data as it is actually organized and structured on the data
storage media.
91) DBMS have a(n) ________ capability to specify the structure of the Knowledge of the
database.
92) Relational DBMSs use ________ rules to ensure that relationships between coupled tables
remain consistent.
93) In a client/server environment, a DBMS is located on a dedicated computer called a(n)
________.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
94) In ________, a data mining tool discovers different groupings within data, such as finding
affinity groups for bank cards.
95) High-speed ________ use both relational and non-relational tools to analyze large datasets.
96) A(n) ________ is software that handles all application operations between browser-based
computers and a company’s back-end business applications or databases.
97) In data mining, the technique of ________ uses a series of existing values to predict what
other values will be.
98) Information is __________when it is available to decision makers when it is needed.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
99) Information is _______________ when it is useful and appropriate for the types of
work and decisions that require it.
100) __________________ is the presence of duplicate data in multiple data files so that the
same data are stored in more than one place or location.
101) __________________ refers to the coupling of data stored in files and the specific
programs required to update and maintain those files so that changes in programs require
changes to the data.
102) A ________________________________ is software that permits an organization to
centralize data, manage them efficiently, and provide access to the stored data by
application programs.
103) ______________________________ use a more flexible data model and are designed for
managing large data sets across many distributed machines and for easily scaling up or
down.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
104) The process of creating small, stable, yet flexible and adaptive data structures from complex
groups of data is called ____________________.
105) A __________________is a subset of a data warehouse in which a summarized or highly
focused portion of the organization’s data is placed in a separate database for a specific
population of users.
106) The small publishing company you work for wants to create a new database for storing
information about all of their author contracts. What factors will influence how you design
the database?
107) When you design the new contracts database for the publishing house mentioned above,
what fields do you anticipate needing? Which of these fields might be in use in other
databases used by the company?
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
108) List at least three conditions that contribute to data redundancy and inconsistency.
109) List and describe three main capabilities or tools of a DBMS.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
110) You have been hired by a national furniture leasing company to implement its first business
intelligence systems and infrastructure. To prepare for your initial report, describe the types
of data in their firm they can use to support business intelligence and the systems that you
will implement to support both their power users and casual users, and explain how these
systems or tools work together.
111) Identify and describe three basic operations used to extract useful sets of data from a
relational database.
112) Describe the ways in which database technologies could be used by an office stationery
supply company to achieve low-cost leadership.
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition
113) Describe the ways in which database technologies could be used by a toy manufacturer to
achieve product differentiation.
114) What makes data mining an important business tool? What types of information does data
mining produce? In what type of circumstance would you advise a company to use data
mining?
115) What are the differences between data mining and OLAP? When would you advise a
company to use OLAP?
Laudon/Laudon/Brabston, Management Information Systems, Seventh Canadian Edition