Database Processing For BIS MCQ

Test your knowledge with important Database Processing For BIS MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Database Processing For BIS MCQs at Bissoy

• Data warehouse data are usually normalized.
  ক

  True

  খ

  False
• OnLine Analytical Processing (OLAP) is a BI reporting system.
  ক

  True

  খ

  False
• A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.
  ক

  True

  খ

  False
• Market basket analysis primarily uses the technique of conditional probabilities.
  ক

  True

  খ

  False
• Formatting the report is part of authoring a report.
  ক

  True

  খ

  False
• The term neural networks as used in data mining is a misnomer.
  ক

  True

  খ

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

  True

  খ

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

  True

  খ

  False
• The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.
  ক

  True

  খ

  False
• In unsupervised data mining, explanations are created after patterns are found.
  ক

  True

  খ

  False
• OLAP uses measures, dimensions and associations.
  ক

  True

  খ

  False
• Report types include static, dynamic, query and OLAP.
  ক

  True

  খ

  False
• 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.
  ক

  True

  খ

  False
• RFM analysis is a BI reporting system.
  ক

  True

  খ

  False
• The data warehouse DBMS needs to be the same DBMS used for the operational database.
  ক

  True

  খ

  False
• Most operational databases can be used for many BI applications.
  ক

  True

  খ

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

  True

  খ

  False
• A data warehouse is a database system that is optimized for operational transaction processing.
  ক

  True

  খ

  False
• 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.
  ক

  True

  খ

  False
• Business Intelligence (BI) systems do not obtain data from operational databases.
  ক

  True

  খ

  False
• 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.
• 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
• 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 ________ .
  ক

  the basic probability

  খ

  support

  গ

  lift

  ঘ

  confidence
• Which of the following is not a reason that operational data are difficult to read?
  ক

  Non-duplicated data

  খ

  Dirty data

  গ

  Missing values

  ঘ

  Non-integrated data
• In OLAP, we are interested in ________ .
  ক

  levels only

  খ

  dimensions only

  গ

  measures only

  ঘ

  measures and dimensions
• 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
• 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
• 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
• 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
• 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