Chapter 7 Exam Style Questions
Chapter 7 Exam Style Questions
Exam-style questions
1 For each of these questions, choose the correct response from the five options
given. [10]
a What validation type would make sure a post code, such as LA21 4NN,
was entered in the correct layout?
a Length check
b Presence check
c Range check
d Format check
e Type check
b What validation type would you use to make sure a number entered was > 0
but not > 100?
a Length check
b Presence check
c Range check
d Format check
e Type check
c What validation type checks that a field in an online form is not left
empty?
a Length check
b Presence check
c Range check
d Format check
e Type check
d What validation type checks that the correct number of characters has
been entered?
a Length check
b Presence check
c Range check
d Format check
e Type check
188
h What is the name given to data which is outside the limits of acceptability?
a Normal
b Live
c Extreme
d Abnormal
e Erroneous
189
190
b State which field would be the most appropriate for the primary key. [1]
c A validation check is used when entering the animal passport number
into the database.
Name and describe the most appropriate validation check that could be
applied to this field. [2]
Cambridge IGCSE Information and Communication Technology (0417) Paper 11 Q9 a, b & c,
May/June 2018
4 In the table below, by using a tick ( ) indicate whether each component
is found in user documentation only, in technical documentation only or
in both types of documentation. [5]
Technical User
Description of component documentation documentation
( ) ( )
How to sort the data
Hardware requirements
How to load and run the software
Program flowcharts/algorithms
Troubleshooting guide/FAQs
Validation rules/routines
Purpose of the system
Program listing/coding
Glossary of terms
Meaning of error messages
5 Put the following six stages of the systems life cycle into their correct order:
» Analysis
» Design
» Development and Testing
» Documentation
» Evaluation
» Implementation [3]
6 Which five computer terms are being described below? [5]
a A changeover method where the old system is stopped overnight and
the new system is introduced straight away.
b A changeover method where the new system is introduced into one
branch of a company and its performance assessed before being
introduced in all the company’s branches.
c Type of validation that checks whether or not the correct number of
characters has been entered.
d Part of the system life cycle that considers data capture forms, file
structures, validation and screen layouts.
e Software development technique where the program is broken down
into smaller parts and each part is tested separately.
191
192
10 Six descriptions are given on the left and ten computer terms are given
on the right. By drawing arrows, connect each description to its
correct term. [6]
Designed to help programmers/analysts User documentation
to make improvements to the system or
repair/maintain the system
Live data
Direct changeover
Actual data used which has known
outcomes
Type check
Technical
Part of a new system is introduced and,
documentation
only when it proves to work satisfactorily,
is the next part introduced, and so on, until
the old system is fully replaced
Abnormal data
Phased
implementation
This is data which is outside the limits
of acceptability or validity and should be
rejected or cause an error message Evaluation stage
193