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

✓ Correct Answer

The correct answer is . This question tests the candidate's understanding of databases within the Computer Sciencesyllabus. The examiner's mark scheme requires...

📋 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...

🔒

Unlock the Examiner's Answer

Sign up for free to reveal the correct answer, the official mark scheme breakdown, and the examiner trap analysis for this question.

Sign Up Free to Unlock →

Join thousands of Cambridge students already using Oracle Prep

About This O-Level Computer Science Question

This structured question appeared in the Cambridge O-Level Computer Science (2210) Oct/Nov 2023 examination, Paper 2 Variant 3. It tests the topic of Databases and is worth 10 marks.

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.

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