Database Processing For Bis MCQs with Explanations

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.

OLAP (Online Analytical Processing) is a category of database processing that supports multidimensional analysis of data for business intelligence purposes. Measures refer to the numeric data values that users want to analyze, such as sales, profit, or revenue. Dimensions are perspectives or entities with respect to which an organization wants to keep records, like time, geography, or product. Associations refer to the relationships between dimensions and measures, allowing users to perform complex queries and drill-down analysis. Therefore, OLAP uses measures, dimensions, and associations to help in effective data analysis and decision-making.

The delivery function of a report management system is designed to distribute reports to intended recipients using various channels. This includes electronic methods such as e-mail, web-based access, and XML Web services, which allow for automated and remote delivery. It may also support manual methods such as hand delivery or printing for physical distribution, depending on organizational needs. The goal is to ensure that reports reach the right users in the right format at the right time. Therefore, the statement is True.

use statistical procedures to predict future events is the correct answer to “A BI reporting system does not ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Process and record transactions only is the correct answer to “Which of the following are not done by Business Intelligence (BI) systems”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Process transactions is the correct answer to “Business Intelligence (BI) systems do not obtain their data by which of the following means”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Too much data is the correct answer to “The "curse of dimensionality" relates to which problem of using operational data for BI reporting”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Pull is the correct answer to “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”. This question is standard in competitive examination syllabi for Database Processing For Bis.

analyze and rank customers is the correct answer to “RFM analysis uses customer's purchasing patterns to ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

frequently is the correct answer to “The "F" in RFM analysis stands for ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

support is the correct answer to “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 ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Modify data is the correct answer to “Business Intelligence (BI) reporting systems cannot do which of the following operations”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Data metadata is the correct answer to “Which of the following is not a component of a data warehouse”. This question is standard in competitive examination syllabi for Database Processing For Bis.

standard SQL only is the correct answer to “Business Intelligence (BI) reporting analyses can be performed using ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

non-integrated data is the correct answer to “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 ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Commercial courier service is the correct answer to “The reports generated by a reporting system are usually not delivered in which of the following media”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Do what-if analysis only is the correct answer to “Data mining applications are used accomplish which of the following tasks”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Cluster analysis only is the correct answer to “Which of the following is an unsupervised data mining technique”. This question is standard in competitive examination syllabi for Database Processing For Bis.

measures and dimensions is the correct answer to “In OLAP, we are interested in ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

Non-duplicated data is the correct answer to “Which of the following is not a reason that operational data are difficult to read”. This question is standard in competitive examination syllabi for Database Processing For Bis.

confidence is the correct answer to “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 ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

RFM analysis only is the correct answer to “One popular classification technique in Business Intelligence (BI) reporting is ________ .”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “Business Intelligence (BI) systems do not obtain data from operational databases.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “A data warehouse is a database system that is optimized for operational transaction processing.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “Most operational databases can be used for many BI applications.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “The data warehouse DBMS needs to be the same DBMS used for the operational database.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

True is the correct answer to “RFM analysis is a BI reporting system.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

True is the correct answer to “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.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

True is the correct answer to “Report types include static, dynamic, query and OLAP.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

True is the correct answer to “In unsupervised data mining, explanations are created after patterns are found.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “BI reporting systems summarize the current status of business activities in order to predict future activities.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

True is the correct answer to “The term neural networks as used in data mining is a misnomer.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

True is the correct answer to “Formatting the report is part of authoring a report.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “Market basket analysis primarily uses the technique of conditional probabilities.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

True is the correct answer to “OnLine Analytical Processing (OLAP) is a BI reporting system.”. This question is standard in competitive examination syllabi for Database Processing For Bis.

False is the correct answer to “Data warehouse data are usually normalized.”. This question is standard in competitive examination syllabi for Database Processing For Bis.