Database Validation Rules Quiz

What is the main reason for applying validation rules in a database?

• To make data entry faster

• To ensure only correct and meaningful data is entered

• To allow duplicate records

• To fix incorrect data automatically

A presence check ensures that:

• A required field is not left blank

• Data is formatted correctly

• A value falls within a specific range

• A number contains only digits

A range check would be used to:

• Ensure an email contains '@'

• Ensure a value is within a specific limit

• Check that a name contains only letters

• Prevent a field from being left blank

What happens when a format check is violated?

• An error message is displayed

• The incorrect data is saved

• The system automatically corrects the input

• The data is deleted

Which validation rule ensures a password contains at least one uppercase letter, one number, and one special character?

• Presence check

• Format check

• Length check

• Range check

A type check ensures that:

• A field contains the correct data type

• A field is not empty

• Data is within a given range

• A number has the correct number of digits

What validation rule should be applied to ensure a student’s score is between 0 and 100?

• Range check

• Format check

• Length check

• Type check

If a system requires users to enter a student ID in the format 'STU1234', which validation rule is needed?

• Type check

• Format check

• Range check

• Presence check

What kind of validation should be used to prevent users from entering letters in a price field?

• Type check

• Length check

• Presence check

• Format check

If a phone number must contain exactly 10 digits, which validation rule should be applied?

• Presence check

• Length check

• Type check

• Format check