N5 DDD Revision

What data type would be best suited for the 'License ID' field?

• Text

• Number

• Grpahic

• Date/Time

What data type would be best suited for the 'Phone No.' field?

• Text

• Number

• Grpahic

• Date/Time

What would be a suitable field size for 'Surname?

• 5

• 20

• 100

• 255

If your client requests that all customers must input a phone number. What validation would be best suited for that field?

• Presence

• Restricted Choice

Which of these would meet the data format for 'D.O.B'?

• 20/04/1999

• 3/8/2001

• 12/2/02

• 12/28/2000

How is this example database being sorted?

• Pupil Name ASC

• Pupils Name DESC

• Pet Name ASC

• Pet Name DESC

How is this example database being sorted?

• Pupil Name ASC

  Pet Age DESC

• Pet Type ASC

  Cost of Pet ASC

• Pet Name ASC

  Cost of Pet ASC

• Pet Type ASC

  Pet Age DESC

Which field would be the best option for a 'Restricted Choice' Validation in a teacher database.

• First Name

• Phone Number

• Address

• Department

In a database of class test results, which field would be best suited for a 'Range' Validation?

• Name

• Class

• Pass/Fail

• Score