Home - Database - Database Processing For Bis

Database Processing For Bis Online Exam Quiz

Important questions about Database Processing For Bis. Database Processing For Bis MCQ questions with answers. Database Processing For Bis exam questions and answers for students and interviews.

1. In OLAP, we are interested in ________ .

Options

A : levels only

B : dimensions only

C : measures only

D : measures and dimensions

2. Which of the following is an unsupervised data mining technique?

Options

A : Cluster analysis only

B : Regression Analysis only

C : RFM Analysis only

D : Both Regression Analysis and RFM Analysis

3. 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 ________ .

Options

A : the basic probability

B : support

C : lift

D : confidence

4. Business Intelligence (BI) reporting analyses can be performed using ________ .

Options

A : standard SQL only

B : extensions to SQL only

C : OLAP only

D : both standard SQL and extensions to SQL

5. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

Options

A : Push

B : Pull

C : RFM

D : OLAP

6. Business Intelligence (BI) reporting systems cannot do which of the following operations?

Options

A : Filter data

B : Group data

C : Modify data

D : Both filter and group data

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

Options

A : cluster analysis only

B : regression analysis only

C : RFM analysis only

D : both cluster analysis and regression analysis

8. Data mining applications are used accomplish which of the following tasks?

Options

A : Process transactions only

B : Do RFM analysis only

C : Do what-if analysis only

D : Do both RFM and what-if analysis

9. A BI reporting system does not ________ .

Options

A : create meaningful information

B : deliver information to users on a timely basis

C : use statistical procedures to predict future events

D : use disparate data sources

10. The reports generated by a reporting system are usually not delivered in which of the following media?

Options

A : Web portal

B : Commercial courier service

C : Digital dashboard

D : E-Mail

1. Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.

Options

A : True

B : False

C :

D :

2. RFM analysis is a BI reporting system.

Options

A : True

B : False

C :

D :

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

Options

A : True

B : False

C :

D :

4. Formatting the report is part of authoring a report.

Options

A : True

B : False

C :

D :

5. BI reporting systems summarize the current status of business activities in order to predict future activities.

Options

A : True

B : False

C :

D :

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

Options

A : True

B : False

C :

D :

7. OLAP uses measures, dimensions and associations.

Options

A : True

B : False

C :

D :

8. Report types include static, dynamic, query and OLAP.

Options

A : True

B : False

C :

D :

9. In unsupervised data mining, explanations are created after patterns are found.

Options

A : True

B : False

C :

D :

10. In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.

Options

A : True

B : False

C :

D :

Database more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.019590139389038