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
✓ 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