DATABASE PROCESSING FOR BIS QUIZ

Analyze past and current activities only

Both of the above are correct.

Process and record transactions only

Neither of the above is correct.

OLAP only

both standard SQL and extensions to SQL

extensions to SQL only

standard SQL only

True

False

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

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

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

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

Read and process data from an operational database

Process data purchased from data vendors

Process extracts from operational databases

Process transactions

the basic probability

confidence

lift

support

False

True

True

False

False

True

Do what-if analysis only

Do both RFM and what-if analysis

Process transactions only

Do RFM analysis only