Quelpr
2 marksManipulating Data in a Database

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

A query was created on the STOCK table and the result is shown in Query2. State the criterion used for the query.

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(a)Name TWO data types other than the TEXT data type used in the stock table.[2 marks]
  2. 8(b)State the field MOST appropriate for use as the primary key and indicate the reason for your choice.[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 Manipulating Data in a Database questions · all CSEC Information Technology past papers