Data Types and Checking Data Entry

Question 1

What are the 6 data types?

Answer 1

Text (can be character, punctuation, mark, letter or number), date, integer, boolean, image, currency

Question 2

How can a data error occur?

Answer 2

It may not be read properly from a data capture sheet

Typing errors occur

Question 3

Name two examples of verification

Answer 3

Proofreading

Double Entry

Question 4

What is presence validation?

Answer 4

It checks that data has been entered

Question 5

What is existence validation?

Answer 5

It checks that the entry matches stored data

Question 6

What is control total data checking?

Answer 6

A calculation that adds up a total of a set of the numbers and checks that the total is meaningful

Question 7

What is hash total data checking?

Answer 7

A calculation that adds up a set of numbers but the total has no meaning

Question 8

What is the difference between validation and verification?

Answer 8

Validation is by a computer but verification is by a person e.g. proof-reading

Question 9

What is range validation?

Answer 9

Checks that the data is within a set range

Question 10

What is length validation?

Answer 10

Checks that the correct number of characters has been entered

Question 11

What is check digit validation?

Answer 11

Checks that the data is allowed or can exist