WorksheetsDatabase Validation
Total questions: 15
Worksheet time: 8mins
What field is best validated using a pattern "*@*.*"?
Customer ID
Date of Birth
Price
What field is best validated using a format DD/MM/YYYY
Customer ID
Date of Birth
Post code
What field is best validated using a currency type?
Customer ID
Date of Birth
Price
What field is best validated using an integer type?
Customer ID
Date of Birth
Price
Gender
What field is best validated by restricting options to a lookup of either Male or Female?
Title
Date of Birth
Gender
What field is best validated by restricting options to a lookup of either Mr, Mrs or Miss?
Title
Date of Birth
Gender
What field is best validated by a presence check?
First Name
Middle Name
What field is best validated by a mask "LL99 9LL"
Post code
Date of Birth
Gender
What field is best validated by type of integer
Telephone Number
Order Quantity
Gender
What field is best validated by type of text
Date of Birth
Telephone Number
Order Quantity
Price
A range validation can be used to validate which of the following (select 2)
Order Quantity
Forename
Price
A lookup validation can be used to validate which of the following (select more than one)
Title
Gender
Forename
Allergic to peanuts
A Boolean type validation can be used to validate which of the following
Title
Gender
Forename
Allergic to peanuts
What field can be validated by a length check that says it must have 4 characters
Forename
PIN
Account number
Account balance
What field can be validated by a length check that says it must have at least 8 characters
Forename
PIN
Password
Account balance
