NEW
Font size
S
M
L
XL
WorksheetsDatabases - Validating Data
Total questions: 10
Worksheet time: 3mins
Name
Class
Date
1.
To decrease the number of mistakes when inputting data into a database, we use two techniques:
a)
Verification and validation.
b)
Validation and virus checking.
c)
Backup and virus checking.
d)
Searching for duplicates and erasing empty rows.
2.
Validates ensures that data is fit for purpose which means the data is:
a)
sensible and reasonable
b)
accurate and fact-checked
c)
spelled correctly
3.
The following is true about validation:
a)
It is performed by software
b)
It is performed by a human
c)
It requires everything to be typed twice, e.g. a new password.
4.
Most database software has sophisticated verification routines.
a)
False
b)
True
5.
When inputting UK customers into a table, this type of validation will prevent non-UK postal codes to be entered:
a)
Format check
b)
Presence check
c)
Range check
d)
Check digit
6.
When inputting credit card customers into a table, this type of validation will prevent invalid numbers to be entered:
a)
All of these
b)
Length check
c)
Check digit
d)
Format check
7.
A user is entering valid but highly unusual data, e.g. age of 113 years. The following is true:
a)
A special routine needs to run, getting the user to confirm and flag this entry up for human verification.
b)
Unusual data is invalid, clearly a person 113 years of age will not be entered in database. It needs to be rejected.
c)
It is possible that a customer can be indeed be 113 years old. The data should be treated as any other.
8.
The following mistakes will not be picked up by any validation:
a)
13 Broad Street instead of 12 Broad Street
b)
0 Broad Street instead of 12 Broad Street
c)
5 Broad Avenue instead of 5 Broad Street
9.
Sometimes validation will prevent valid data from being input
a)
True
b)
False
10.
Validation checks if data is correct
a)
False
b)
True
Reset
