O-LevelComputer ScienceDatabasesOct/Nov 2025Paper 2 Q710 Marks
A database table WATERFOWL stores some details of a range of birds found in the UK that live on or near water. The length and wingspan dimensions are in centimetres and the typical lifespan is in years. Species Family Length Wingspan CoastalHabitat Lifespan Barnacle goose Goose 63.5 130.0 FALSE 14 Bewick's swan Swan 120.2 190.5 TRUE 8 Brent goose Goose 58.0 94.3 TRUE 11 Canada goose Goose 78.5 160.0 FALSE 6 Eider Duck 58.0 94.5 TRUE 8 Goldeneye Duck 44.5 72.1 TRUE 6 Goosander Duck 63.3 90.0 TRUE 7 Long-tailed duck Duck 44.0 76.6 TRUE 5 Mallard Duck 59.7 90.8 FALSE 3 Mute swan Swan 150.0 220.2 FALSE 10 Pink-footed goose Goose 69.6 150.0 TRUE 8 Pintail Duck 60.0 88.6 TRUE 3 Smew Duck 41.5 62.1 FALSE 7 White-fronted goose Goose 71.5 140.0 FALSE 6 Whooper swan Swan 150.0 230.0 TRUE 9
📋 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