MIS Chapter 3 Study Test

46 Questions | Total Attempts: 697

SettingsSettingsSettings
Please wait...
MIS Quizzes & Trivia

.


Questions and Answers
  • 1. 
    Which data administration facility allows you to control who has access to what information and what type of access those people have?
    • A. 

      Security management facilities

    • B. 

      Query optimization facilities

    • C. 

      Reorganization facilities

    • D. 

      Concurrency control facilities

  • 2. 
    A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?
    • A. 

      Online analytical processing (OLAP)

    • B. 

      Geographic information systems (GIS)

    • C. 

      Enterprise resource planning (ERP)

    • D. 

      Decision support systems (DSS)

  • 3. 
    Which type of constraint ensures the quality of information in a relational database?
    • A. 

      Environmental constraint

    • B. 

      Business constraint

    • C. 

      Integrity constraint

    • D. 

      Production constraint

  • 4. 
    Which application supports the manipulation of information to support decision making?
    • A. 

      OLTP

    • B. 

      CRM

    • C. 

      ERP

    • D. 

      OLAP

  • 5. 
    Which organizational function is responsible for the more technical and operational aspects of managing information repositories?
    • A. 

      Strategic management

    • B. 

      Database administration

    • C. 

      Information resource planning

    • D. 

      Operational planning

  • 6. 
    A(n) _____ is a field or group of fields that uniquely describes each record.
    • A. 

      Identifying key

    • B. 

      Relational key

    • C. 

      Primary key

    • D. 

      Main key

  • 7. 
    In a data warehouse, which data-mining tool would you use to quickly build reports without having to write programming code?
    • A. 

      Application report generator

    • B. 

      Artificial intelligence

    • C. 

      Multidimensional analysis tools

    • D. 

      Query-and-reporting tools

  • 8. 
    What type of software tool is used to query information stored in a data warehouse?
    • A. 

      OLTP

    • B. 

      Data dictionary

    • C. 

      Data-mining

    • D. 

      Decision support

  • 9. 
    Which term refers to a specific piece of information that is stored in a database file?
    • A. 

      Relation

    • B. 

      Category

    • C. 

      Class

    • D. 

      Attribute

  • 10. 
    If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?
    • A. 

      Logical view

    • B. 

      Physical view

    • C. 

      Stored view

    • D. 

      Objective view

  • 11. 
    _____ refers to collective information that gives you the ability to make effective, important, and often strategic business decisions.
    • A. 

      Query-by-example

    • B. 

      Business intelligence

    • C. 

      Information analysis

    • D. 

      SQL

  • 12. 
    Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?
    • A. 

      Query reporting tools

    • B. 

      SQL reports

    • C. 

      Report generators

    • D. 

      Application reports

  • 13. 
    A(n) _____ key is a primary key of one file that appears in another file.
    • A. 

      Foreign

    • B. 

      Secondary

    • C. 

      Identifying

    • D. 

      Duplicate

  • 14. 
    _____ is the process of reinstalling the backup information in the event the information was lost.
    • A. 

      Recovery

    • B. 

      Recycling

    • C. 

      Retrieval

    • D. 

      Reproduction

  • 15. 
    SQL is:
    • A. 

      A standardized fourth generation language found in most DBMSs.

    • B. 

      A storage tool that holds the data and definitions for a database.

    • C. 

      An administrative tool that allows you to set access rights for database users.

    • D. 

      A programming language that can be used instead of a DBMS.

  • 16. 
    _____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.
    • A. 

      Online analytical processing (OLAP)

    • B. 

      Business intelligence (BI)

    • C. 

      File management systems (FMS)

    • D. 

      Online transaction processing (OLTP)

  • 17. 
    What must you define before adding any information to a relational database?
    • A. 

      The intended audience

    • B. 

      The physical hardware structure

    • C. 

      The administrative rights of users

    • D. 

      The logical structure of the database

  • 18. 
    Data warehouses exist to support:
    • A. 

      MRP

    • B. 

      OLAP.

    • C. 

      OLTP.

    • D. 

      SQL.

  • 19. 
    _____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.
    • A. 

      KPIs

    • B. 

      DPIs

    • C. 

      QBEs

    • D. 

      SQLs

  • 20. 
    If you were to perform a regression analysis, what type of data warehouse tool would it be?
    • A. 

      Statistical

    • B. 

      Multidimensional analysis

    • C. 

      Production analysis

    • D. 

      Hypercube

  • 21. 
    If the file containing your student information appears in two different places with two different birth dates, your data would not be considered ____.
    • A. 

      Legitimate

    • B. 

      Valid

    • C. 

      Clean

    • D. 

      Acceptable

  • 22. 
    What is the most popular model for creating databases?
    • A. 

      Hierarchical database model

    • B. 

      Object-oriented database model

    • C. 

      Ecological database model

    • D. 

      Relational database model

  • 23. 
    Which part of a relational database contains the logical structure for the information?
    • A. 

      Data dictionary

    • B. 

      Relation

    • C. 

      Query

    • D. 

      SQL

  • 24. 
    If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view is it?
    • A. 

      Logical view

    • B. 

      High-level view

    • C. 

      Subjective view

    • D. 

      Physical view

  • 25. 
    Databases that support OLTP are most often referred to as ____.
    • A. 

      OLAP

    • B. 

      Data warehouses

    • C. 

      Relational databases

    • D. 

      Operational databases