978-0134238241 Chapter 6 Part 2

Unlock access to all the studying documents.

View Full Document

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?

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?

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?

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?

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?

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?

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?

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?

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?