Database Validation

What field is best validated using a pattern "*@*.*"?

• Customer ID

• Date of Birth

• Price

• Email

What field is best validated using a format DD/MM/YYYY

• Customer ID

• Date of Birth

• Post code

• Email

What field is best validated using a currency type?

• Customer ID

• Date of Birth

• Price

• Email

What field is best validated using an integer type?

• Customer ID

• Date of Birth

• Price

• Email

• Gender

What field is best validated by restricting options to a lookup of either Male or Female?

• Title

• Date of Birth

• Email

• Gender

What field is best validated by restricting options to a lookup of either Mr, Mrs or Miss?

• Title

• Date of Birth

• Email

• 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

• Email

• Gender

What field is best validated by type of integer

• Email

• Telephone Number

• Order Quantity

• Gender

What field is best validated by type of text

• Date of Birth

• Telephone Number

• Order Quantity

• Price