Home / CSE / Database System 2 - CS :: Database Processing for BIS

CSE :: Database System 2 - CS

  1. Business Intelligence (BI) systems do not obtain data from operational databases.

  2. A.

     True

    B.

     False


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

  4. A.

     True

    B.

     False


  5. A data warehouse is a database system that is optimized for operational transaction processing.

  6. A.

     True

    B.

     False


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

  8. A.

     True

    B.

     False


  9. Most operational databases can be used for many BI applications.

  10. A.

     True

    B.

     False


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

  12. A.

     True

    B.

     False


  13. RFM analysis is a BI reporting system.

  14. A.

     True

    B.

     False


  15. 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.

  16. A.

     True

    B.

     False


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

  18. A.

     True

    B.

     False


  19. OLAP uses measures, dimensions and associations.

  20. A.

     True

    B.

     False