Database Management Concepts Quiz! Test

44 Questions | Total Attempts: 174

SettingsSettingsSettings
Please wait...
Database Management Concepts Quiz! Test

How strong is your knowledge of database management concepts? A database is a collection of data with the same characteristics. The database management system a firm uses is expected to use the ability to transfer data and retrieval of the same. By taking this quiz, you will see just how good you are at using a database management system in the application. Test yourself and see what you need to work more on.


Related Topics
Questions and Answers
  • 1. 
    If you have a database containing information about students, then all the information about one student would be referred to as a _____.
    • A. 

      Table

    • B. 

      Field

    • C. 

      Record

    • D. 

      File

  • 2. 
    If you have a database containing information about students, then the student's last name would be an example of a _____.
    • A. 

      Table

    • B. 

      Field

    • C. 

      Record

    • D. 

      File

  • 3. 
    Within an Access table, each record is represented by one _____.
    • A. 

      Row

    • B. 

      Column

    • C. 

      Datasheet

    • D. 

      File

  • 4. 
    Within an Access table, each field is represented by one _____.
    • A. 

      Row

    • B. 

      Column

    • C. 

      Datasheet

    • D. 

      File

  • 5. 
    Each database must contain at least one _____.
    • A. 

      Table

    • B. 

      Form

    • C. 

      Report

    • D. 

      Module

  • 6. 
    Use this view to display a table in columns and rows.
    • A. 

      Form view

    • B. 

      Design view

    • C. 

      Table view

    • D. 

      Datasheet view

  • 7. 
    The first step in designing a new database is _____.
    • A. 

      Entering data

    • B. 

      Building queries

    • C. 

      Planning the tables

    • D. 

      Printing reports

  • 8. 
    _____ is a field, or combination of fields, that uniquely identifies each record in a table.
    • A. 

      Data type

    • B. 

      Form

    • C. 

      Relationship

    • D. 

      Primary key

  • 9. 
    Which of the following is NOT a part of the Query Design window?
    • A. 

      Criteria

    • B. 

      Field

    • C. 

      Or

    • D. 

      Data type

  • 10. 
    _____ is a column in a table that contains a category of information.
    • A. 

      Field

    • B. 

      Table

    • C. 

      Query

    • D. 

      Label

  • 11. 
    Which Data Type would you use for the field "First Name"?
    • A. 

      Text

    • B. 

      Memo

    • C. 

      Number

    • D. 

      Currency

    • E. 

      Yes/No

  • 12. 
    All of the following are Data Types in Access EXCEPT _____.
    • A. 

      Sort

    • B. 

      Date/Time

    • C. 

      Yes/No

    • D. 

      OLE Object

    • E. 

      Attachment

  • 13. 
    Which Data Type would you use for the field "Basic Salary"?
    • A. 

      Text

    • B. 

      Memo

    • C. 

      Number

    • D. 

      Currency

    • E. 

      Yes/No

  • 14. 
    A report is an effective way of presenting your data in an organized format.
    • A. 

      True

    • B. 

      False

  • 15. 
    A _____ is a unit of information in a _____.
    • A. 

      Record, field

    • B. 

      Data source, field

    • C. 

      Record, data source

    • D. 

      Field, record

  • 16. 
    An organized collection of logically related data is known as _____.
    • A. 

      Meta data

    • B. 

      Data

    • C. 

      Database

    • D. 

      Information

  • 17. 
    Which type of field is incremented automatically?
    • A. 

      Auto Elevate

    • B. 

      AutoNumber

    • C. 

      Auto Increment

    • D. 

      Auto Value

  • 18. 
    Which of the following is NOT a view for interacting with a form object?
    • A. 

      Layout view

    • B. 

      Datasheet view

    • C. 

      Design view

    • D. 

      Form view

  • 19. 
    Which Data Type is better to use for storing a phone number in the following format: 304-555-5555?
    • A. 

      Text

    • B. 

      Currency

    • C. 

      AutoNumber

    • D. 

      Number

  • 20. 
    Which of the following is a valid Data Type in Access?
    • A. 

      Hyperlink

    • B. 

      Currency

    • C. 

      Memo

    • D. 

      OLE Object

    • E. 

      Attachment

    • F. 

      All are valid Data Types

    • G. 

      All except Attachment

  • 21. 
    What is the intersection of a row and a column?
    • A. 

      Cursor

    • B. 

      Form

    • C. 

      Record

    • D. 

      Cell

  • 22. 
    What determines a table's sort order?
    • A. 

      AutoNumber field

    • B. 

      Field order

    • C. 

      Primary key

    • D. 

      Index field

  • 23. 
    Which tool do you use to create a query object?
    • A. 

      Simple filter wizard

    • B. 

      Table query wizard

    • C. 

      Database wizard

    • D. 

      Simple query wizard

  • 24. 
    Which object(s) can be used to create a form?
    • A. 

      Queries and reports

    • B. 

      Tables only

    • C. 

      Tables and queries

    • D. 

      Tables and reports

  • 25. 
    What is the purpose of indexing?
    • A. 

      To reduce table size

    • B. 

      To speed up data search

    • C. 

      Both A and B

    • D. 

      Neither A nor B