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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  6. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  8. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  10. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. RFM analysis is a BI reporting system.

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. OLAP uses measures, dimensions and associations.

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum