Data validation and verification

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 uses the last one or two digits to check the other digits are correct?

• Length check

• Format check

• Check digit

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 of the following is NOT a method of verification?

• Double entry - typing the data in twice and getting the computer to check the second version against the first

• Using presence, range and length checks to make sure that no mistakes happen

• Printing out what you have typed in and comparing it against the source data

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

• Presence check

• Format check

• Lookup

• Mobile Phone