3.2.3 Data validation tools Quiz: OCR IT, Unit 1

The 20 questions

1. Which validation check rejects a value that is not the expected type, such as text entered into a number field?

   • Data type check
   • Presence check
   • Range check
   • Length check

2. Which check makes sure a value follows a pattern, such as the structure of a postcode?

   • Limited choice
   • Length check
   • Format check
   • Presence check

3. Which tool guides the user to enter a fixed pattern, such as dd/mm/yyyy, as they type?

   • Double entry
   • Lookup
   • Range check
   • Input mask

4. A field must hold exactly eight characters. Which check ensures this?

   • Length check
   • Data type check
   • Format check
   • Presence check

5. Which tool lets a user choose from a fixed set of options, such as a drop-down list or radio buttons?

   • Limited choice
   • Input mask
   • Length check
   • Presence check

6. Which validation tool checks that a value exists in a table held elsewhere, such as a list of valid product codes?

   • Format check
   • Presence check
   • Data type check
   • Lookup

7. Which check makes sure a required field is not left empty?

   • Lookup
   • Presence check
   • Range check
   • Format check

8. A score field accepts values from 0 to 100. Which check is used?

   • Data type check
   • Input mask
   • Length check
   • Range check

9. A drop-down list of colours stops users typing an invalid colour. Which check is this?

   • Presence check
   • Format check
   • Length check
   • Limited choice

10. An hours-worked field accepts 0 to 40. A value of 45 is entered. Which check rejects it?

    • Range check
    • Data type check
    • Presence check
    • Input mask

11. A tick list lets a user select several interests. Which validation tool is this?

    • Lookup
    • Length check
    • Limited choice
    • Format check

12. A phone number field must hold exactly 11 digits. Which check best matches this rule?

    • Lookup
    • Range check
    • Presence check
    • Length check

13. Which validation tools check a fixed pattern and an existing list?

    • Length and type
    • Format and lookup
    • Range and presence
    • Presence and format

14. A form accepts a date of birth but the user leaves it blank. Which check should block the submission?

    • Presence check
    • Lookup
    • Length check
    • Format check

15. How do validation tools reduce user errors?

    • Backing up files
    • Rejecting unreasonable entries
    • Comparing source documents
    • Correcting spelling mistakes

16. What benefit do validation tools provide to stored records?

    • Speeding up downloads
    • Preventing invalid data
    • Encrypted storage
    • Increasing file compression

17. A form stores the number of tickets as a whole number. Which check stops decimals being entered?

    • Presence check
    • Input mask
    • Data type check
    • Range check

18. Which check rejects a code not found in a permitted list?

    • Type check
    • Range check
    • Lookup check
    • Length check

19. Why might a designer combine several validation tools on one field?

    • Speeding up processing
    • Ensuring source truth
    • Reducing file size
    • Catching more errors

20. A text box asks for a percentage from 0 to 100 but accepts the text high. Which check catches this first?

    • Presence check
    • Length check
    • Range check
    • Data type check

Related quizzes

• Types of design tools Quiz · 1.1 · 20 questions
• The purpose, importance and use of HCI in application areas Quiz · 2.1 · 20 questions
• Hardware considerations Quiz · 2.2 · 20 questions
• Software considerations Quiz · 2.3 · 20 questions
• User interaction methods Quiz · 2.4 · 20 questions
• Information and data Quiz · 3.1 · 20 questions
• Use of data types in different contexts Quiz · 3.2.1 · 20 questions
• The difference between validation and verification Quiz · 3.2.2 · 20 questions
• Data verification tools Quiz · 3.2.4 · 20 questions
• Data collection methods Quiz · 3.3 · 20 questions