Quelpr
2 marksDatabase Terminology

CSEC Information Technology · 2015 · Paper 2 · Question 8(a)

A database table named STOCK storing computer and related equipment information.

Name TWO data types other than the TEXT data type used in the stock table.

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. 8(b)State the field MOST appropriate for use as the primary key and indicate the reason for your choice.[2 marks]
  2. 8(c)A query was created on the STOCK table and the result is shown in Query2. State the criterion used for the query.[2 marks]
  3. 8(d)(i)From the ITEMS REPORT generated from the table, state the field used to group the records.[1 mark]
  4. 8(d)(ii)State which field was used to sort the records in the report.[1 mark]

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