Data Validation and Verification Quiz

Which of these is an example of a Presence Check?

• Checking if a date is between 01/01/1900 and 31/12/2025.

• Ensuring a field is not left blank.

• Checking if a password has at least one uppercase letter.

Answer explanation

A Presence Check verifies that a field is filled out. Therefore, 'Ensuring a field is not left blank' is the correct example, while the other options involve validation of specific content rather than presence.

A Range Check ensures data is in the correct format (like an email format).

• True

• False

Answer explanation

A Range Check verifies that data falls within specified limits, not its format. Therefore, the statement is False.

Type Check is used to confirm the data entered is of the correct ____ (e.g., text, number, date).

Answer explanation

Type Check is used to confirm the data entered is of the correct type, such as text, number, or date. This ensures that the data conforms to expected formats, making 'type' the correct choice.

Which type of validation rule checks that data meets a specific pattern (like “AB12 3CD” for a postal code)?

• Length Check

• Format Check

• Range Check

Answer explanation

A Format Check validates that data conforms to a specific pattern, such as a postal code format like 'AB12 3CD'. This ensures the data is structured correctly, unlike Length or Range Checks which focus on size or numerical limits.

Verification is the process of creating rules in a database to ensure the data is sensible.

• True

• False

Answer explanation

True. Verification involves establishing rules in a database to ensure that the data entered is logical and meets certain criteria, thus maintaining data integrity.

Give one example of verification in everyday life (1–2 sentences).

Answer explanation

An example of verification in everyday life is checking a receipt against purchased items to ensure all charges are correct. This process confirms that the transaction matches what was intended.

Which rule ensures a phone number field must have exactly 10 digits?

• Range Check

• Presence Check

• Length Check

Answer explanation

The Length Check rule ensures that a phone number field contains exactly 10 digits. It specifically validates the number of characters, making it the correct choice for this requirement.

A student is entering data for a school art competition. The “Artwork Size” must be between 1 cm and 100 cm. Which validation rule would you use?

Answer explanation

Use a validation rule that checks if the 'Artwork Size' is greater than or equal to 1 cm and less than or equal to 100 cm. This ensures the input falls within the specified range.

Why is it important for a database to use both validation and verification?

Answer explanation

Validation ensures data is correct and meets specified criteria, while verification confirms that the data is accurate and consistent. Together, they enhance data integrity and reliability in a database.