Deck 24: How Businesses Use Databases

Question 1

Which of the following is NOT a data mining technique?

A) Classification
B) Estimation
C) Clustering
D) Reporting

Answer 1

D

Question 2

A(n) ________ is software that is used to gather and analyze data.

Answer 2

information system

Question 3

Match each of the following terms to its definition:
I. artificial intelligence
II. data mart
III. exception report
IV. fuzzy logic
V. time-variant data
A. MIS report generated to show unusual situations that require attention
B. branch of computer science that attempts to create computers that think like humans
C. small slice of related data from a data warehouse
D. data that is not limited to a particular time period
E. uses probabilities to inject experiential learning in knowledge-based systems

Answer 3

B, C, A, E, D

Question 4

Extracting and reformatting data from each source so all data is consistent and then storing the data is known as ________.

A) data warehousing
B) data staging
C) database management
D) OLAP

Question 5

________ software provides flexible viewing and manipulation of data in a data warehouse.

A) SQL
B) OLAP
C) RDMS
D) Access

Question 6

A(n) ________ system is a large software system that gathers information from all parts of a business and integrates it to make it readily available for decision making.

Question 7

________ data is data that doesn't pertain to one period of time.

A) Time-variant
B) Data mart
C) Cyclical
D) Clickstream

Question 8

As a business grows, it needs to ________.

A) use spreadsheets to manage its operations
B) use a database management system that can collect and store data from multiple sources
C) use departmental databases
D) use a combination of a central database and departmental databases

Question 9

A small subset of data from a data warehouse is known as a(n) ________.

A) query
B) data mart
C) OLAP
D) table

Question 10

Which of the following is NOT a typical data source for Data Warehouses?

A) Internal sources
B) External sources
C) Hyperlink data
D) Clickstream data

Question 11

A large-scale collection of data that consolidates data from various operational systems is known as a(n)________.

A) data warehouse
B) data mart
C) database management system
D) relational database

Question 12

________ systems are used mostly at the executive level to improve business decision making with databases and other fact-based support systems.

Question 13

________ systems include expert systems and natural language processing as part of a DSS.

Question 14

________ is the process by which great amounts of data are analyzed and investigated for significant patterns or trends within the data.

A) Data mining
B) Data collection
C) Data warehousing
D) Data marting

Question 15

A(n) ________ is a type of information system that tracks transactions.

Question 16

A(n) ________ provides timely and accurate information for critical business decisions