What is an example of a Data Type Check?

Only Yes or No can be entered into a Boolean field

All pupils have a score of 0 up to 100

All children in a primary school are between 4 and 11 years old

Number must fall between a lower and upper limit

What does a Range Check ensure in data validation?

Data falls within a specified range

Data is entered in alphabetical order

To check that data has been entered into a field

To ensure data is entered in the correct format

To verify the length of the entered data

A credit card number must be 16 characters long

To ensure a lengthy list of numbers is entered correctly

To ensure data is entered in the correct format

To verify the length of the entered data

A-Z accepted, data entry required

A-Z accepted, data entry not required

0-9 accepted, data entry required

All characters converted to lowercase

Converts all following characters to uppercase

Converts all following characters to lowercase

A collection of related or structured information held on a computer

A collection of unrelated information

Data that is repeated or duplicated unnecessarily

Data that is unique and only appears once

It increases the size of the database and decreases data integrity

It decreases the size of the database

The accuracy and consistency of data stored in the database

It has no effect on data redundancy

Tables are linked through common fields

Data is stored in a single file

Does not support data integrity

Ability to create queries and reports using more than one table

Data is stored in a flat file format

By entering data only once into the database

By storing data in multiple locations

By allowing data to be entered multiple times