Data validation

Question 1

What is the purpose of Data Validation?

Answer 1

To ensure that data is sensible, reasonable, complete and within acceptable boundaries.

Question 2

What does a Presence Check do?

Answer 2

Ensures that data has been entered into a field.

Question 3

What does a Length Check verify?

Answer 3

Ensures that data entered has the correct number of characters or does not exceed a certain number of characters.

Question 4

What is the function of a Type Check?

Answer 4

Ensures that data entered is of the correct data type.

Question 5

Name a few data types that a Type Check might validate.

Answer 5

• Numeric
• Text
• Date/Time
• Yes/No (Boolean)
• Currency

Question 6

What does a Format Check ensure?

Answer 6

Ensures that data entered is of an exact format, possibly matching an input mask.

Question 7

What is the purpose of a Range Check?

Answer 7

Ensures that data entered is within an acceptable range, possibly between a lower and upper boundary.

Question 8

Fill in the blank: A Presence Check ensures that _______ has been entered into a field.

Answer 8

[data]

Question 9

Fill in the blank: A Length Check ensures that data entered has the correct number of _______.

Answer 9

[characters]

Question 10

True or False: A Format Check can ensure that a date is entered in the correct format.

Answer 10

True

Question 11

True or False: A Range Check can be used to determine if a password is within a specified length.

Answer 11

False

Question 12

What is a Lookup Table?

Answer 12

A list of data which can be used to provide values for other data fields.