WorksheetsN5 DDD Revision
Total questions: 9
Worksheet time: 5mins
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
