ExamVeda
Login
Home

Database Processing for BIS - Database MCQ Questions and answers- Technical Aptitude

Database Processing for BIS(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-2 section-1

11
Business Intelligence (BI) reporting analyses can be performed using ________ .
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
12
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 ________ .
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
13
The reports generated by a reporting system are usually not delivered in which of the following media?
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
14
Data mining applications are used accomplish which of the following tasks?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
15
Which of the following is an unsupervised data mining technique?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
16
In OLAP, we are interested in ________ .
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
17
Which of the following is not a reason that operational data are difficult to read?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
18
We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
19
One popular classification technique in Business Intelligence (BI) reporting is ________ .
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
20
We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
Discuss
Answer & Solution
Answer: Option B
Solution:
RFM analysis is a marketing technique used to evaluate and categorize a customer’s behavior based on three factors:

R (Recency): How recently the customer has made a purchase.

F (Frequency): How often the customer makes a purchase.

M (Monetary): How much money the customer spends when they make a purchase.

Each factor is typically scored on a scale from 1 to 5, where:

1 indicates the lowest or worst performance, and 5 indicates the highest or best performance.

In Mary’s case, her RFM score is "1 1 5":

R = 1 → She hasn’t ordered recently.

F = 1 → She orders infrequently.

M = 5 → When she does order, she spends a large amount.

Therefore, Mary is classified as someone who hasn’t ordered recently, orders rarely, but places large orders when she does.