IGCSE COMPUTER SCIENCE PAPER #2
KNOWLEDGE EXAM QUESTIONS WITH
COMPLETE ANSWERS
Verification - Answer-Used to check that the data does not change as it is being
entered.
Presence check - Answer-checks to ensure that some data has been entered and the
value has not been left blank
Type check - Answer-checks that data entered is of a given data type
Format check - Answer-checks that the characters entered conform to a pre defined
pattern
Length check/character check - Answer-checks when a string of characters is entered it
does not contain any invalid characters or symbols.
Lookup check - Answer-checks for records in a set of reference data that are related to
those that you are currently working with.
Range Check - Answer-checks that only numbers that are entered are between certain
values
Why are databases useful in preventing data problems occurring? - Answer-Data is only
stored once - no duplication. If any changes or additions are made it only to be done
once- the data is consistent. The same data can be shared and used by everyone
Field - Answer-one specific piece of information about a single item, person or event.
Example of a field in a hospital - Answer-date of admission, first name, family name.
Example of a field in library - Answer-ISBN, author, title
Record - Answer-contains data about an object, person, or other type of table item
Example of a record in library - Answer-IGCSE Computer Science, The sport gene.
Example of a record in hospital - Answer-Winne Sing, Michelle Wong (a patients name)
Tables - Answer-contains data about one type of item, person or event
KNOWLEDGE EXAM QUESTIONS WITH
COMPLETE ANSWERS
Verification - Answer-Used to check that the data does not change as it is being
entered.
Presence check - Answer-checks to ensure that some data has been entered and the
value has not been left blank
Type check - Answer-checks that data entered is of a given data type
Format check - Answer-checks that the characters entered conform to a pre defined
pattern
Length check/character check - Answer-checks when a string of characters is entered it
does not contain any invalid characters or symbols.
Lookup check - Answer-checks for records in a set of reference data that are related to
those that you are currently working with.
Range Check - Answer-checks that only numbers that are entered are between certain
values
Why are databases useful in preventing data problems occurring? - Answer-Data is only
stored once - no duplication. If any changes or additions are made it only to be done
once- the data is consistent. The same data can be shared and used by everyone
Field - Answer-one specific piece of information about a single item, person or event.
Example of a field in a hospital - Answer-date of admission, first name, family name.
Example of a field in library - Answer-ISBN, author, title
Record - Answer-contains data about an object, person, or other type of table item
Example of a record in library - Answer-IGCSE Computer Science, The sport gene.
Example of a record in hospital - Answer-Winne Sing, Michelle Wong (a patients name)
Tables - Answer-contains data about one type of item, person or event
