Quiz #7: Databases

Show all answers     Hide all answers

    Completion

  1. DBMS stands for ________ ________ ________ ________. Answer DataBase Management System
  2. DBA stands for ________ ________ ________. Answer DataBase Administrator
  3. ERD stands for ________ ________ ________. Answer Entity Relationship Diagram
  4. OLAP stands for ________ ________ ________ ________. Answer OnLine Analytical Processing
  5. SQL stands for ________ ________ ________. Answer Structured Query Language
  6. Storing the data together with procedures that manipulate the data is called ________. Answer encapsulation
  7. ________ refers to how objects created from simpler objects automatically inherit all the data and procedures of the simpler object. Answer Inheritance
  8. A ________ key is a key that is made up from more than one field. Answer composite
  9. Data ________ refers to storing more than one copy of some data, which is considered a bad practice. Answer redundancy

    10. Short answer

  10. List the steps in moving data from a regular database to a data warehouse. Answer The checking steps may be left out in the answer, but don't forget them in real life.
    • extract from the current database the data that you want to put into the data warehouse
    • transform the extracted data into the form you want to store it in
    • check to make sure everything is accurate
    • merge/load the data into the data warehouse
    • perform additional checks to ensure accuracy

    11. Matching

    Identify the letter of the choice that best matches the phrase or definition.

    1. entity
    2. character
    3. field
    4. record
    5. table/file
    6. database
    7. query
    8. schema
    9. data dictionary
    10. entity relationship diagram
    11. index
    12. key field
    13. primary key
    14. foreign key
    15. data mining
    16. data warehouse
  11. a repository of information about data being stored Answer I (data dictionary)
  12. considered the smallest unit of data in a database Answer B (character)
  13. a collection of fields related to the same entity Answer D (record)
  14. any object about which information is collected Answer A (entity)
  15. one piece of information about an entity Answer C (field)
  16. a field which identifies a record - not always uniquely Answer L (key field)
  17. a collection of related files/tables Answer F (database)
  18. a blueprint showing the structure of a database Answer H (schema)
  19. used by the database to make accessing records faster and maintain sort orders Answer K (index)
  20. a collection of related records Answer E (table/file)
  21. a field which refers to a field within a record in another table Answer N (foreign key)
  22. a graphical representation of all entity relationships Answer J (entity relationship diagram)
  23. a large database used to support management decision making Answer P (data warehouse)
  24. a field which identifies a record uniquely Answer M (primary key)
  25. looking for trends, patterns, or other information in the data contained in databases Answer O (data mining)
  26. a request for specific information Answer G (query)