Quelpr
1 markManipulating Data in a Database

CSEC Information Technology · January 2014 · Paper 2 · Question 8(d)(i)

How many fields will be displayed when the query shown in the grid is executed?

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)State the name of the table used to store data in the database.[1 mark]
  2. 8(b)Which field in the table can be used as the primary key?[1 mark]
  3. 8(c)If the records in the table are sorted from the newest to the oldest member, what will be the Membership_No. of the member who would be at the TOP of the…[1 mark]
  4. 8(d)(ii)How many records will be displayed when the query shown in the grid is executed?[1 mark]
  5. 8(e)A report is generated from the database table. State TWO fields which could be used to group the data.[2 marks]

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