Database Processing for BIS - General Questions Online Exam Quiz

Database Processing for BIS - General Questions GK Quiz. Question and Answers related to Database Processing for BIS - General Questions. MCQ (Multiple Choice Questions with answers about Database Processing for BIS - General Questions

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

View Answer

Which of the following are not done by Business Intelligence (BI) systems?

Options

A : Analyze past and current activities only

B : Process and record transactions only

C : Both of the above are correct.

D : Neither of the above is correct.

View Answer

Business Intelligence (BI) systems do not obtain their data by which of the following means?

Options

A : Read and process data from an operational database

B : Process transactions

C : Process extracts from operational databases

D : Process data purchased from data vendors

View Answer

The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

Options

A : Dirty data

B : Inconsistent data

C : Too much data

D : Non-integrated data

View Answer

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

View Answer

RFM analysis uses customers' purchasing patterns to ________ .

Options

A : record transactions

B : analyze and rank customers

C : predict future sales using regression techniques

D : perform OLAP

View Answer

The "F" in RFM analysis stands for ________ .

Options

A : frequently

B : freshness

C : fast food

D : fantasy

View Answer

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

View Answer

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

View Answer

Which of the following is not a component of a data warehouse?

Options

A : Data extraction/cleaning/preparation programs

B : Data warehouse data

C : Data metadata

D : None of the above are data warehouse components.

View Answer

Advanced SQL - General Questions more Online Exam Quiz

Properties - General Questions

Structures - General Questions

Advanced SQL - General Questions

Data and Database Administration - General Questions

Database Design Using Normalization - General Questions

Database Redesign - General Questions

Data Modeling with ER Model - General Questions

Data Warehousing - General Questions

Distributed Databases - General Questions

Introduction to Database - General Questions