Is 290

20 Questions  I  By Scottb21
Please take the quiz to rate it.

Person Quizzes & Trivia

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.