21/MJ/16

Paper 21/MJ/16

Cambridge O'Level 2210 Computer Science

Multiple Select

Which lines need to be changed?

• 1 Small = 100

• 2 Counter = 0

• 3 REPEAT

• 4 INPUT Num

• 5 IF Num < Small THEN Small = Num

Changes Needed

• Change variable name in every instance as needs to be meaningful e.g. Large

• Set this variable to a low value

• line 5: change comparison from < to >

Multiple Choice

Data type for name

• string/text

• char/string

• number/integer

• boolean

Multiple Choice

Data type for gender

• string/text

• char/string

• number/integer

• boolean

Multiple Choice

Data type for status (junior or senior)

• string/text

• char/string

• number/integer

• boolean

Multiple Choice

Data type for team member (yes or no)

• string/text

• char/string

• number/integer/real

• boolean

Multiple Choice

Data type for fee

• string/text

• char/string

• number/integer/real

• boolean

Open Ended

The swimming club has 50 members. State the data structure that would be most suitable to use and give a reason for your choice.

Reasons to use an Array in Programming

• to simplify programming

• to make programs shorter

• to identify the same member across the arrays (using index)

Multiple Select

What are the three loop structure (repetition statements)?

• do-loop until

• for-next loop

• while-wend loop

• if-else

• select-case

Description of Loop Structures

Multiple Choice

A loop structure that has a set number of iterations.

• do-loop until

• while-wend

• for-next loop

Multiple Select

These loop structures are used where the loop may never be executed/whilst a specified condition exists.

• do-loop until

• while-wend

• for-next loop

Open Ended

Q6a. Explain why none of the fields in the database can be used as a primary key

Multiple Choice

STAFFNUMBER can be used as a primary key.

• TRUE

• FALSE

STAFFNUMBER can be used as a primary key.

because it uniquely identifies each member of staff//no duplicates//different for each member of staff