CSEC Information Technology · May/June 2013 · Paper 2 · Question 8(c)
Write the criteria to search the database table for all the persons who owe more than $500.00.
The mark scheme is shown once you've answered.
Practise this questionOther parts of this question
- 8(a)Complete the database structure table by specifying Field Name, Data Type, and Field Description to store the given customer data.[3 marks]
- 8(b)State a field name from the list you have provided in (a) above that can be used as a primary key.[1 mark]
- 8(d)State the feature of a database management system that prints data in a specified format with a title.[1 mark]
More practice: the rest of this paper · more Manipulating Data in a Database questions · all CSEC Information Technology past papers