Quelpr

CSEC Information Technology · January 2013 · Paper 2 · Question 7(a)

Table 2 shows the structure of a YOUTH table with fields: IDNo, Name, DOB, Phone.

State an appropriate data type for EACH of the fields: Name, DOB and Phone.

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(b)State the MOST appropriate field that should be a primary key.[1 mark]
  2. 7(c)Write a query to obtain the names of ALL youths born after 31 December 1994.[4 marks]

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