Data entry checks
These questions will check that you are clear about the difference between the different types of data checks that are used.
-
A computer user is setting up a new online email account and is asked to enter their new password twice. This is an example of what type of data check?
- A verification check
- A validation check
- A presence check
- A range check
-
A database user accidentally types in the number 99.9 instead of 9.99 for the price of a DVD. The database program will not accept the entry and an error message pops up on the screen telling the user about the mistake. What type of data check is this?
- A presence check
- A validation check
- A verification check
-
A database user enters data into a database. A second user then enters the same data again and the two entries are compared with each other by the software. What type of data check is this?
- A verification check
- A validation check
- A presence check
- A range check
-
A database user in a second-hand garage dealership is entering the details of a car that has just arrived. They enter Renalt instead of Renault in the car make field. The database will not accept the entry and pups up a message stating the entry can not be accepted. What type of data check has caused this to happen?
- A validation check
- A verification check
- A presence check
- A range check
-
An Internet user wants to log onto their online bank account. They are asked to enter their username and PIN number. What type of data checks are these?
- Verification checks
- Validation checks
- A presence check
- A range check
-
An Internet user wants to log onto their online bank account. They notice that next to the entry boxes there is a notice stating that the username must be at least 6 characters long and can have letters and numbers but no spaces. What kind of data check is this?
- A validation check
- A verification check
- A presence check
- A range check
-
A database designer wants to make sure that the user of a vehicle database enters as few mistakes as possible. In the 'CAR DOORS' field they only want the user to be able to enter the numbers 2, 3, 4 or 5. What type of data check and field type would only allow the correct entries?
- Setting the field type to be integer number with a validation check such as:
BETWEEN 2 AND 5 - Setting the field type to be real number with a validation check such as:
BETWEEN 2 AND 5 - Setting the field type to be integer number with a validation check such as:
> 2 AND <5 - Setting the field type to be integer number with a verification check such as:
BETWEEN 2 AND 5
- Setting the field type to be integer number with a validation check such as:
-
A database designer wants to make sure that the user of a database of video and DVD details enters a few mistakes as possible. In the 'CERTIFICATE' field they only want the user to be able to enter the values PG, U, 15 or 18. What type of data check and field type would only allow the correct entries?
- Setting the field type to be alphanumeric (text) with a validation member list check such as:
"18" OR "15" OR "PG" OR "U" - Setting the field type to be alphanumeric (text) with a verification member list check such as:
"18" OR "15" OR "PG" OR "U" - Setting the field type to be alphanumeric (text) with a validation member list check such as:
"18" AND "15" AND "PG" AND "U" - Setting the field type to be numeric with a validation member list check such as:
"18" OR "15" OR "PG" OR "U"
- Setting the field type to be alphanumeric (text) with a validation member list check such as:
-
A policeman stops a motorist and passes their registration details through to the DVLA vehicle database to check if matches the vehicle description. What type of data check is this.
- A verification check.
- A validation check
- A range check
- A presence check
-
A database user is entering the details of a customer into a database but realises that they cannot read the customer's date of birth. They decide to leave that field blank and come back to it when the details have been checked over the phone. However the database software will not let them leave the field blank. What type of data check is causing this?
- There must be a presence check on the field so it cannot be left blank.
- There must be a validation range-check on the field so it cannot be left blank.
- There must be a verification check on the field so it cannot be left blank.