Database Processing for BIS MCQs

Question 1

One popular classification technique in Business Intelligence (BI) reporting is ________ .

Accepted Answer

RFM analysis only

Answer

cluster analysis only

Answer

regression analysis only

Answer

both cluster analysis and regression analysis

Question 2

We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .

Accepted Answer

Has ordered recently, orders frequently, but doesn't place a large order when she orders

Answer

Has ordered recently, orders frequently, and places a large order when she orders.

Answer

Hasn't ordered recently, orders infrequently, but places a large order when she orders.

Answer

Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

Question 3

Business Intelligence (BI) systems do not obtain data from operational databases.

Accepted Answer

False

Answer

True

Question 4

Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.

Accepted Answer

False

Answer

True

Question 5

A data warehouse is a database system that is optimized for operational transaction processing.

Accepted Answer

False

Answer

True

Question 6

Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.

Accepted Answer

False

Answer

True

Question 7

Most operational databases can be used for many BI applications.

Accepted Answer

False

Answer

True

Question 8

The data warehouse DBMS needs to be the same DBMS used for the operational database.

Accepted Answer

False

Answer

True

Question 9

RFM analysis is a BI reporting system.

Accepted Answer

True

Answer

False