Validation Rules Quiz

Which of the following describes a “Presence Check”?

• Data must follow a particular pattern (like an email format).

• Data must be within a certain numeric or date range.

• Data must not be left empty in a required field.

• Data must not exceed a certain number of characters.

Which validation rule ensures data follows a specific format or pattern (for example, a postal code with letters and numbers)?

• Range Check

• Format Check

• Type Check

• Presence Check

What does a “Range Check” do?

• It checks if a field is non-empty.

• It ensures no duplicates appear in a field.

• It ensures data is within a minimum–maximum limit.

• It checks that data has a specific length.

Which validation rule is used if you need a field to have exactly 10 digits (e.g., a phone number)?

• Length Check

• Type Check

• Format Check

• Presence Check

Which rule verifies that data is of the correct data type (e.g., only numbers where numbers are required)?

• Uniqueness Check

• Length Check

• Type Check

• Presence Check

What is the main purpose of a “Uniqueness Check”?

• To ensure data follows a pattern like “AB12 3CD.”

• To ensure no two records contain the same value in a certain field.

• To ensure data is between a lower and upper limit.

• To ensure no required field is left blank.

Which rule ensures that different fields within the same record make logical sense when compared (e.g., ‘End Date’ cannot be before ‘Start Date’)?

• Cross-Field (Consistency) Check

• Presence Check

• Range Check

• Format Check

A postal service database must ensure each entry for “Postal Code” is exactly 6 characters long. Which validation rule would be most appropriate?

• Range Check

• Presence Check

• Length Check

• Format Check

Which validation rule ensures that data comes from a pre-defined set of possible entries (like a drop-down list of countries)?

• A. Lookup (List) Check

• B. Format Check

• C. Type Check

• D. Presence Check

If a school database wants to ensure that “Age” is always a number between 5 and 18, which two validation rules are most likely being used?

• A. Format Check and Length Check

• B. Presence Check and Type Check

• C. Type Check and Range Check

• D. Uniqueness Check and Cross-Field Check