Quelpr
2 marksManipulating Data in a Database

CSEC Information Technology · May/June 2019 · Paper 2 · Question 7(c)

Write the results of a query that lists the learner drivers assigned to Rick.

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. 7(a)Identify the field that could be used as a primary key, and state ONE reason why it may NOT be a suitable primary key.[2 marks]
  2. 7(b)(i)Complete the table to show two field names and their data types that could be used in an Instructor table.[2 marks]
  3. 7(b)(ii)Identify the field name from the Instructor table that would be MOST suitable as a primary key.[1 mark]

More practice: the rest of this paper · more Manipulating Data in a Database questions · all CSEC Information Technology past papers