Database Validation Rules Quiz

What is the purpose of validation rules in a database?

• To prevent users from entering data

• To ensure data is accurate and consistent

• To store additional information

• To delete duplicate records

Which of the following is an example of a presence check?

• Ensuring an email field contains '@'

• Preventing a student’s initial from being left blank

• Making sure a number is between 1 and 100

• Checking if a phone number is exactly 10 digits

A length check is used to:

• Ensure a value falls within a certain range

• Restrict the number of characters in a field

• Check for blank fields

• Verify a specific format for input

What validation rule would prevent a student’s grade from being below 1 or above 8?

• Presence check

• Range check

• Length check

• Format check

What happens when a format check is applied?

• It ensures the data is not empty

• It checks if a value follows a specific pattern

• It verifies that a field only contains numbers

• It compares values from two different fields

In MS Access, a validation rule is set in which field property?

• Default Value

• Input Mask

• General Properties

• Data Type

If a field requires a currency value, which validation type should be used?

• Type check

• Range check

• Presence check

• Length check

What would be an appropriate validation rule for a session date field?

• SessionDate >= Date()

• SessionDate = Date()

• SessionDate = NULL

• SessionDate 7 OR Stage = 7 AND Stage <= 11

What type of validation would best ensure a student's name contains only letters?

• Type check

• Range check

• Format check

• Presence check

If a user enters '12th' instead of '12' for a student’s grade, what validation check should be applied?

• Format check

• Presence check

• Type check

• Range check