Module 5 Theory Questions

10 Questions | Attempts: 2245
Share

SettingsSettingsSettings
Module Quizzes & Trivia

Questions and Answers
  • 1. 
    Which one of the following is responsible for providing users with access to the appropriate data.
    • A. 

      A database administrator.

    • B. 

      A database architect

    • C. 

      A database designer.

    • D. 

      A database user.

  • 2. 
    Which one of the following outcomes is a result of adding an index?
    • A. 

      Records can be searched and sorted efficiently

    • B. 

      All records can be quickly deleted

    • C. 

      Tables in a database can be related

    • D. 

      Records can be entered into a database.

  • 3. 
    What is a database
    • A. 

      A structured collection of records or data

    • B. 

      A data structure that improves search operations in a table

    • C. 

      A program for creating online forms

    • D. 

      A set of instruction used retrieving data from a table

  • 4. 
    Which one of the following is the purpose of relating tables in a database?
    • A. 

      To permit external data only to be viewed

    • B. 

      To allow data to be sorted before printing to a report

    • C. 

      To enable mathematical calculations to be carried out more efficiently.

    • D. 

      To reduce duplication of data

  • 5. 
    Which one of the following prevents you adding a record to a related table when there is no associated record in the primary table?
    • A. 

      A primary key.

    • B. 

      Relational integrity

    • C. 

      A validation rule.

  • 6. 
    Each field in a table should contain …
    • A. 

      More than one data element

    • B. 

      No data elements

    • C. 

      Only one data element

    • D. 

      Any number of data elements

  • 7. 
    Which one of the following can result from reducing the size of a field in a table? 
    • A. 

      Loss or corruption of data in the table.

    • B. 

      Changes to reports which access the table.

    • C. 

      An increase in the number of records in the table.

    • D. 

      A decrease in the number of records in the table.

  • 8. 
    Which one of the following is used to assign a unique identity to a record?
    • A. 

      A validation rule.

    • B. 

      A form.

    • C. 

      A primary key.

    • D. 

      A filter.

  • 9. 
    Which one of the following is the purpose of a primary key
    • A. 

      To select a field size.

    • B. 

      To select a date type.

    • C. 

      To assign each record a unique identity.

    • D. 

      To save all records in a table.

  • 10. 
    Which of the following is an appropriate data type for a field containing decimal values
    • A. 

      AutoNumber

    • B. 

      Number

    • C. 

      Text

    • D. 

      Memo

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.