Quelpr
1 markDatabase Terminology

CSEC Information Technology · May/June 2019 · Paper 2 · Question 12(a)(i)

A one-dimensional array Num_of_payments indexed by student Reference storing payment counts.

State the reference for the student who has to make three payments.

This question uses a figure or table from the paper — you'll see it when you practise.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 12(a)(ii)State the number of payments for the student with reference 56.[1 mark]
  2. 12(a)(iii)State the maximum number of students whose information can be stored in the array.[1 mark]
  3. 12(a)(iv)State the meaning of '...' as shown in the array.[2 marks]
  4. 12(a)(v)State the data type for the number of payments.[1 mark]
  5. 12(b)Using the numbers 1, 2, 3 and 4, write the order in which the given sequence of statements are used in a Pascal program.[4 marks]
  6. 12(c)(i)State the purpose of 'count := 0;'.[1 mark]
  7. 12(c)(ii)What does PAYMENT refer to in the fragment code?[1 mark]
  8. 12(c)(iii)State the purpose of the fragment code.[3 marks]

More practice: the rest of this paper · more Database Terminology questions · all CSEC Information Technology past papers