MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Database Processing For BIS
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Q.1
A data warehouse is a database system that is optimized for operational transaction processing.
True
False
Q.2
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.
True
False
Q.3
One popular classification technique in Business Intelligence (BI) reporting is ________ .
cluster analysis only
regression analysis only
RFM analysis only
both cluster analysis and regression analysis
Q.4
We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
Has ordered recently, orders frequently, and places 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, 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.
Q.5
Most operational databases can be used for many BI applications.
True
False
Q.6
RFM analysis uses customer's purchasing patterns to ________ .
record transactions
analyze and rank customers
predict future sales using regression techniques
perform OLAP
Q.7
The "F" in RFM analysis stands for ________ .
frequently
freshness
fast food
fantasy
Q.8
We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .
the basic probability
support
lift
confidence
Q.9
Business Intelligence (BI) reporting analyses can be performed using ________ .
standard SQL only
extensions to SQL only
OLAP only
both standard SQL and extensions to SQL
Q.10
We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
dirty data
inconsistent data
non-integrated data
a "wrong format" problem
Q.11
The reports generated by a reporting system are usually
not
delivered in which of the following media?
Web portal
Commercial courier service
Digital dashboard
E-Mail
Q.12
Business Intelligence (BI) reporting systems
cannot
do which of the following operations?
Filter data
Group data
Modify data
Both filter and group data
Q.13
Which of the following is
not
a component of a data warehouse?
Data extraction/cleaning/preparation programs
Data warehouse data
Data metadata
None of the above are data warehouse components.
Q.14
Data mining applications are used accomplish which of the following tasks?
Process transactions only
Do RFM analysis only
Do what-if analysis only
Do both RFM and what-if analysis
Q.15
Which of the following is an unsupervised data mining technique?
Cluster analysis only
Regression Analysis only
RFM Analysis only
Both Regression Analysis and RFM Analysis
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page