Database Essentials 1

25 Questions | Total Attempts: 664

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

This database exam will test your knowledge of basic concepts and terms associated with creating databases.


Related Topics
Questions and Answers
  • 1. 
    In a database containing information about North Carolina and its counties, how would you find the county with the most people?
    • A. 

      Filter the population field using >10,000

    • B. 

      Rank the counties by name and scroll through the list

    • C. 

      Search each county record

    • D. 

      Sort the records by population in descending order

  • 2. 
    When creating a database about African countries, what type of field would the square miles (land size) be?
    • A. 

      Logical

    • B. 

      Miles

    • C. 

      Number

    • D. 

      Text

  • 3. 
    What is the arrangement of data in a field in alphabetical order?
    • A. 

      Filing

    • B. 

      Numbering

    • C. 

      Searching

    • D. 

      Sorting

  • 4. 
    What is another term for the categories when creating a database?
    • A. 

      Entry

    • B. 

      Field

    • C. 

      File

    • D. 

      Record

  • 5. 
    Which is NOT a field type to consider when creating a database?
    • A. 

      Date

    • B. 

      Item

    • C. 

      Number

    • D. 

      Text

  • 6. 
    What are the four parts of a database listed in ascending order?
    • A. 

      Entry, field, file, record

    • B. 

      Entry, field, record, file

    • C. 

      File, field, entry, record

    • D. 

      File, record, field, entry

  • 7. 
    What term applies to a collection of  related records in a database?
    • A. 

      Clipboard

    • B. 

      Field

    • C. 

      File

    • D. 

      Form

  • 8. 
    If books are organized from the most expensive to the cheapest, what is the sort order?
    • A. 

      Ascending

    • B. 

      Criterion

    • C. 

      Descending

    • D. 

      Numerical

  • 9. 
    What item could an electronic database be compared to?
    • A. 

      Copier

    • B. 

      Fax machine

    • C. 

      File cabinet

    • D. 

      Telephone

  • 10. 
    What do you call words like "and" and "or" when you are filtering, querying, or searching records?
    • A. 

      Commands

    • B. 

      Connectors

    • C. 

      Forms

    • D. 

      Operators

  • 11. 
    What is a group of related fields known as?
    • A. 

      Characters

    • B. 

      Data

    • C. 

      Files

    • D. 

      Records

  • 12. 
    What feature displays records that meet a specific criteria from a database?
    • A. 

      Edit

    • B. 

      Filter

    • C. 

      Recall

    • D. 

      View

  • 13. 
    Which is NOT true about database programs?
    • A. 

      Are an excellent way to organize information

    • B. 

      Can be printed

    • C. 

      Can find information quickly

    • D. 

      Can only hold up to 100 records

  • 14. 
    What is a wildcard?
    • A. 

      A character to take the place of an unknown

    • B. 

      A symbol such as

    • C. 

      A way of sorting values in a deck of cards

    • D. 

      An ace of spades

  • 15. 
    Why might a student use an electronic database?
    • A. 

      Average his or her grades for math class

    • B. 

      Keep tract of friends' names and addresses

    • C. 

      Send an e-mail message to his or her parents

    • D. 

      Write a report for a history class

  • 16. 
    What does descending order mean?
    • A. 

      A to Z alphabetical order

    • B. 

      Connecting order

    • C. 

      Search numerical order

    • D. 

      Z to A alphabetical order

  • 17. 
    Why would a travel agent use a database?
    • A. 

      Communicate with cruise ships

    • B. 

      Forecast the summer season

    • C. 

      Get airline schedules for clients

    • D. 

      Print vacation brochures

  • 18. 
    What type of software is designed to act as an electronic filing cabinet organizing collections of data?
    • A. 

      Database

    • B. 

      Desktop publishing

    • C. 

      Spreadsheet

    • D. 

      Word processing

  • 19. 
    How would you find the phone number of one particular student from 500 names and addresses of students enrolled at your school?
    • A. 

      Perform a search of all boys in the database

    • B. 

      Perform a search using the student's name as the criteria

    • C. 

      Sort the database and scroll through the records

    • D. 

      Sort the database in descending order

  • 20. 
    What is NOT a reason a business might use a computerized database?
    • A. 

      Designing a brochure for advertising purposes

    • B. 

      Keeping an appointment calendar with patients or customers

    • C. 

      Keeping their inventory up to date

    • D. 

      Maintaining a list of loyal customers

  • 21. 
    How do you write the mathematical operator "less than"?
    • A. 

      =/

    • B. 

      =

    • C. 

      >

    • D. 

  • 22. 
    How do you write the mathematical operator "equal to or greater than"?
    • A. 

      =&

    • B. 

      =>

    • C. 

      =

    • D. 

      =+

  • 23. 
    If you had a database of names and phone numbers, what would LAST NAME, FIRST NAME, and PHONE NUMBER be examples of?
    • A. 

      Data

    • B. 

      Entries

    • C. 

      Fields

    • D. 

      Records

  • 24. 
    What operator would you use for the word "exceeds"?
    • A. 

    • B. 

      >

    • C. 

      =>

    • D. 

      =

  • 25. 
    Which operator would you use for the words "at most"?
    • A. 

      >

    • B. 

    • C. 

      =>

    • D. 

      =