20
71) Most back-end databases are able to interpret HTML commands.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
72) Hadoop can process large quantities of any type of data, including video and Twitter feeds.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
73) The two key services of Hadoop are HDFS and in-memory computing.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
74) A data warehouse may include information from legacy systems.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
75) A data warehouse is typically comprised of several smaller data marts.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
76) OLAP is a key tool of BI.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
21
77) OLAP is used to find hidden patterns and relationships in large databases, and infer rules
from these to determine future behavior.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
78) In-memory computing relies on a computer’s main memory for storing data.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
79) Implementing a web interface for a database requires changes to the database itself.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
80) Common Gateway Interface is a specification for processing data on a web server.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
81) In linking databases to the web, the role of the application server is to host the DBMS.
AACSB: Information Technology
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
22
82) List and describe three main capabilities or tools of a DBMS.
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
83) Describe the ways in which database technologies could be used by an office stationery
supply company to achieve low-cost leadership.
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
23
84) Explain what big data refers to. What benefits does it have, and what challenges does it
pose?
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
85) What are the differences between data mining and OLAP? When would you advise a
company to use OLAP?
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
24
86) 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?
AACSB: Information Technology; Written and Oral Communication
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
87) What are the similarities and differences between a data warehouse and a data mart?
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
88) Imagine you are running a growing business with an active presence on social media. How
would you better understand what your customers think about your business using these
platforms?
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
25
89) Within a corporate information services department, the task of establishing the physical
database and its logical relations are responsibilities of the ________ function.
A) data management
B) data administration
C) server administration
D) data modeling
E) database administration
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
90) The confusion created by ________ makes it difficult for companies to create customer
relationship management, supply chain management, or enterprise systems that integrate data
from different sources.
A) batch processing
B) data redundancy
C) data independence
D) online processing
E) data freedom
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
91) 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.
E) data repair.
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
26
92) A(n) ________ is a structured survey of the accuracy and level of completeness of the data in
an information system.
A) data quality audit
B) systems analysis
C) systems audit
D) data analysis
E) data overview
AACSB: Application of Knowledge
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
93) Common data quality problems include all of the following except:
A) misspelled names.
B) transposed numbers.
C) incorrect codes.
D) missing codes.
E) Internet connectivity problems.
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
94) A firm’s information policy lays out who is responsible for updating and maintaining the
information in a database system.
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
95) Redundant data often stems from the use of different codes to identify the same data in a
firm’s various information systems.
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
96) Data cleansing is the same process as data scrubbing.
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
27
97) An information policy specifies the procedures and rules for defining the structure and
content of corporate databases.
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
98) Data administration is a special organizational function that manages the policies and
procedures through which data can be managed as an organizational resource.
AACSB: Information Technology
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
99) List at least two ways that a business’s data can become redundant or inconsistent.
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?
100) Why might you receive multiple pieces of the same piece of mail, or multiple emails
featuring the same promotion?
AACSB: Analytical Thinking; Written and Oral Communication
LO: 6.4: Why are information policy, data administration, and data quality assurance essential
for managing a firm’s data resources?