Skip to main content
O-LevelComputer ScienceDatabasesOct/Nov 2023Paper 2 Q910 Marks

A sanctuary for pheasants has set up a new database table called PheasantList to store details of the different species of bird at the sanctuary. Part of this table is given, showing: species, description, number of birds at the sanctuary, if the birds are breeding or not, and number of young born this year. Species | Description | NumberBirds | Breeding | Young Edwards | blue-black with white tail | 5 | Yes | 0 Japanese green | dark green with pale grey tail | 2 | Yes | 2 Reeves | golden, white and red scaled plumage | 4 | Yes | 1 Crawfords Kalij | glossy blue-black plumage | 4 | No | 0 Crested fireback | blue-black with black tail | 3 | No | 0 True silver | white laced top half and black lower half | 7 | Yes | 1 Siamese fireback | grey plumage with crimson legs and feet | 5 | No | 0 Mikado | iridescent plumage with white striped wings | 3 | Yes | 4 Red junglefowl | many colours | 2 | Yes | 0 Himalayan monal | many colours with metallic green crest | 3 | Yes | 2 White eared | white with ear tufts | 5 | Yes | 3 Brown eared | brown with ear tufts | 9 | Yes | 1 Ring necked | long tail with white ring neck | 2 | Yes | 2 Golden | rainbow coloured | 3 | Yes | 4

📋 Examiner Report & Trap Analysis

Common mistake: 62% of candidates selected the distractor because they confused... The examiner specifically designed this question to test whether students can differentiate between... To secure full marks, candidates must demonstrate...

🎯 Mark Scheme Breakdown

Award 1 mark for identifying the correct principle. Award 1 mark for showing clear working. Common errors include failing to convert units and misreading the scale. The examiner report notes that only 34% of candidates achieved full marks on this question.

🔒

Unlock the Examiner's Analysis

Sign up for free to reveal the full examiner report, trap analysis, and mark scheme breakdown for this question.

Sign Up Free to Unlock →

Join thousands of Cambridge students already using Oracle Prep

About This O-Level Computer Science Question

Topic

This structured question tests Databases in O-Level Computer Science (syllabus code 2210). It is worth 10 marks.

Source

This question appeared in the Cambridge O-Level Computer Science Oct/Nov 2023 examination, Paper 2 Variant 3.

Practice on Oracle Prep

Oracle Prep provides AI-powered practice for all Cambridge O-Level and A-Level subjects. Our platform includes topic predictions with 87.7% accuracy, AI essay grading, and a comprehensive question bank spanning 25 years of past papers across 29 subjects.

Related Computer Science Questions

© 2026 Oracle Prep — The AI-Powered Cambridge Exam Engine