Data Validation

What is an automatic computer check to make sure data entered is sensible and reasonable known as?

• Double entry
• Verification
• Validation

What validation type would make sure a post code was entered in the correct format?

• Length check
• Format check
• Presence check

What validation type would you use to check that numbers fell within a certain range?

• Range check
• Presence check
• Check digit

What validation type checks that a field is not left blank?

• Format check
• Length check
• Presence check

What validation type checks a minimum number of characters have been entered?

• Length check
• Format check
• Range check

Data is to be entered into a computer in the format YYMMDD. Which of the following is not a valid date?

• 310921
• 211113
• 21st June 2004

Which of the following statements is false?

• Validation can check that the data is sensible
• Validation can check that the data falls between certain allowable boundaries
• Validation can check that the data is correct

Which method of validation would be ideal for a shop to use when entering information into a stock database?

• Presence check
• Format check
• Lookup

I want to ensure that users enter a name into the Surname field. Which type of validation should I use?

• Length check

• Check digit

• Presence check

• Format check

I want to ensure that users enter a national insurance number that follows the pattern letter letter number number number number number number letter?

• Length check

• Format check

• Check Digit

• Presence Check