Module 5 Theory Questions

10 Questions  I  By Jackie_mac
Please take the quiz to rate it.

Module 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. 
    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

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.