Related Topics
Take Another Quiz

Is 290

20 Questions
Person Quizzes & Trivia
Questions and Answers
  • 1. 
    What is the primary problem with redundant information?
    • A. 

      It is often inconsistent

    • B. 

      It is difficult to determine which values are the most accurate

    • C. 

      All of the above

  • 2. 
    What is an integration?
    • A. 

      Takes information entered into a given system and sends it to the database

    • B. 

      Takes information entered into a given system and sends it to the DBMS

    • C. 

      Allows separate systems to communicate directly with each other

  • 3. 
    What are the rules that enforce basic and fundamental information-based constraits?
    • A. 

      Relational integrity constrait

    • B. 

      Information integrity

    • C. 

      Integrity constrait

  • 4. 
    In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
    • A. 

      Entity

    • B. 

      Physical view

    • C. 

      Attribute

  • 5. 
    Why do relational databases use primary keys and foreign keys?
    • A. 

      To create a database

    • B. 

      To create physical relationships

    • C. 

      To create logical relationships

  • 6. 
    Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships?
    • A. 

      Hierarchical database

    • B. 

      Network database

    • C. 

      Relational database model

  • 7. 
    What refers to how well a system can adapt to increased demands?
    • A. 

      Performance

    • B. 

      Scalability

    • C. 

      Redundancy

  • 8. 
    All of the following are advantages of database-stored information, except
    • A. 

      Increased flexibility

    • B. 

      Increased performance

    • C. 

      Increased information integrity

  • 9. 
    Which of the following measures how quickly a system performs a certain process or transaction?
    • A. 

      Redundancy

    • B. 

      Scalability

    • C. 

      Performance

  • 10. 
    What type of website is best to build for a general information website with static information?
    • A. 

      Relational website

    • B. 

      Data-driven website

    • C. 

      Static website

  • 11. 
    What is information redundancy?
    • A. 

      Duplication of information

    • B. 

      Storing the same information in multiple places

    • C. 

      All of the above

  • 12. 
    What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
    • A. 

      Relational integrity constrait

    • B. 

      Business-critical integrity constraint

    • C. 

      Information-critical integrity constraint

  • 13. 
    What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?
    • A. 

      Customer-driven database

    • B. 

      Data-driven website

    • C. 

      Data-driven database

  • 14. 
    In the relational database model, what are characteristics or properties of an entity?
    • A. 

      Attribute

    • B. 

      Logical view

    • C. 

      Physical view

  • 15. 
    What type of website is best to build for a website with continually changing information including press releases, new product info, and updated pricing?
    • A. 

      Data-driven website

    • B. 

      Static website

    • C. 

      Relational website

  • 16. 
    What is a foreign key?
    • A. 

      A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables

    • B. 

      A field that uniquely identitifies a given attribute in a table

    • C. 

      Characteristics or properties of an entity

  • 17. 
    Which of the following are the principle BI enablers?
    • A. 

      Technology, people, and customer culture

    • B. 

      Technology, people, and corporate culture

    • C. 

      Technology, processes, and customer culture

  • 18. 
    What is a dimension?
    • A. 

      A particular attribute of information

    • B. 

      A particular relational database

    • C. 

      A particular single repository

  • 19. 
    What do data warehouses support?
    • A. 

      OLTP

    • B. 

      OLAP

    • C. 

      Analytical processing

  • 20. 
    A database warehouse is a _____ collection of information-gathered from many different___ databases-that support business analysis activities and decision-making tasks.
    • A. 

      Logical, transactional

    • B. 

      Physical, operational

    • C. 

      Logical, operational