Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
11
41) Identify and describe the three basic operations used to extract useful sets of data from a
relational database?
AACSB: Information Technology; Written and Oral Communication
LO: 6.2: What are the principles of a database management system?
42) Describe the process of querying and reporting in a database using DBMS.
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.2: What are the principles of a database management system?
43) What are some of the benefits of using the cloud as a database platform?
AACSB: Application of Knowledge; Written and Oral Communication
LO: 6.2: What are the principles of a database management system?
44) MongoDB and SimpleDB are both examples of:
A) open-source databases.
B) SQL databases.
C) NoSQL databases.
D) cloud databases.
E) big data databases.
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?
12
45) Access is a:
A) DBMS for mobile devices.
B) popular open-source DBMS.
C) DBMS for midrange computers.
D) DBMS for desktop PC systems.
E) DBMS for mainframe computers.
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?
46) In clustering, a data mining tool will find:
A) new groupings within data.
B) related predictions from existing values.
C) several events grouped by time.
D) new associations.
E) forecasts for future events.
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?
47) MySQL is a:
A) DBMS for mobile devices.
B) programming language.
C) mainframe relational DBMS.
D) DBMS for desktop systems.
E) popular open-source 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?
48) Data mining is more ________ than OLAP.
A) data-focused
B) multidimensional
C) query oriented
D) discovery driven
E) streamlined
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?
13
49) All of the following are tools or technologies for extracting information from unstructured
data sets except:
A) sentiment analysis software.
B) SQL queries.
C) Hadoop.
D) a non-relational DBMS.
E) text mining.
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?
50) DBMS typically include report-generating tools in order to:
A) retrieve and display data.
B) display data in tables.
C) display data in graphs.
D) perform predictive analysis.
E) display data in an easier-to-read-format.
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?
51) Which of the following database types would be best suited for storing multimedia?
A) SQL DBMS
B) Open-source DBMS
C) Non-relational DBMS
D) Cloud-based database
E) NoSQL 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?
14
52) Pre-configured hardware-software systems that use both relational and non-relational
technology optimized for analyzing large datasets are referred to as:
A) hybrid DBMS.
B) Hadoop.
C) BI.
D) analytic platforms.
E) 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?
53) Which of the following statements about data warehouses is not true?
A) They store supply data to be used across the enterprise for management analysis and decision
making.
B) Data warehouse systems provide a range of ad hoc and standardized query tools, analytical
tools, and graphical reporting facilities.
C) They may include data from website transactions.
D) Data warehouse systems provide easy-to-use tools for managers to easily update data.
E) Data warehouses make data available for anyone to access as needed.
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?
54) A data mart usually can be constructed more rapidly and at lower cost than a data warehouse
because:
A) it typically focuses on a single subject area or line of business.
B) all the information is historical.
C) it uses a web interface.
D) all of the information belongs to a single company.
E) it is open-source.
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?
15
55) Tools for consolidating, analyzing, and providing access to vast amounts of data to help
users make better business decisions are known as:
A) DSS.
B) business intelligence.
C) OLAP.
D) data mining.
E) 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?
56) Which of the following enables users to view the same data in different ways using multiple
dimensions?
A) Hadoop
B) SQL
C) Big data
D) Data mining
E) OLAP
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?
57) OLAP is a tool that enables users to:
A) obtain online answers to ad hoc questions in a rapid amount of time.
B) view both logical and physical views of data.
C) quickly diagram data relationships.
D) normalize data.
E) find hidden patterns in large databases.
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?
16
58) Data mining is a tool for allowing users to:
A) quickly compare transaction data gathered over many years.
B) perform multidimensional data analysis.
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.
E) find hidden relationships in 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?
59) In terms of the data relationships found by data mining, 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.
E) classification when no groups have yet been defined.
AACSB: Application of Knowledge
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
60) In terms of the data relationships found by data mining, sequences 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.
E) classifications when no groups have yet been defined.
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?
17
61) Which of the following would you use to find patterns in user interaction data recorded by
web servers?
A) Web usage mining
B) Web server mining
C) Web structure mining
D) Web content mining
E) Web protocol mining
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?
62) Which of the following would you use to find out which websites with content related to
database design were the most often linked to by other websites?
A) Web usage mining
B) Web server mining
C) Web structure mining
D) Web content mining
E) Web protocol mining
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?
63) Businesses use ________ tools to search and analyze unstructured data sets, such as emails
and memos.
A) Hadoop
B) web mining
C) text mining
D) OLAP
E) 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?
18
64) Hadoop is a(n):
A) NoSQL database technology that stores both data and procedures acting on the data as
objects.
B) data mining platform designed for storing and analyzing big data produced by web
communications and transactions.
C) open-source software framework designed for distributing data-processing over inexpensive
computers.
D) pre-configured hardware-software system designed for analyzing big data.
E) high-speed platform used to analyze large data sets.
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?
65) A data ________ stores current and historical data of potential interest to decision makers
throughout the company.
A) warehouse
B) mart
C) archive
D) mine
E) center
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?
66) A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.
A) web server
B) online server
C) database server
D) client server
E) application 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?
19
67) Which of the following is an example of a company whose business model is based on
access to large databases through the web?
A) Gartner
B) Fortune
C) IBM
D) Microsoft
E) Facebook
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?
68) Links pointing to an online document are a sign of:
A) richness or variety of topics covered.
B) popularity.
C) data quality.
D) data usage.
E) marketing.
AACSB: Application of Knowledge
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
69) Links coming out of an online document are a sign of:
A) richness or variety of topics covered.
B) popularity.
C) data quality.
D) data usage.
E) marketing.
AACSB: Application of Knowledge
LO: 6.3: What are the principal tools and technologies for accessing information from databases
to improve business performance and decision making?
70) Web mining is the discovery of useful patterns on the web.
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?
