O-LevelComputer ScienceDatabasesOct/Nov 2022Paper 2 Q78 Marks
A school uses a database table, ASSESS, to keep a record of the internal assessments and the number of candidates for each of the subjects in its curriculum. SubjectCode | SubjectName | Exams | Practicals | Candidates ------------|----------------------|-------|------------|------------ COMP | Computer Science | 2 | 1 | 200 INFO | Information Technology | 1 | 2 | 200 MATH | Mathematics | 3 | 0 | 350 PHYS | Physics | 2 | 1 | 120 CHEM | Chemistry | 2 | 1 | 120 BIOL | Biology | 2 | 1 | 200 GEOG | Geography | 2 | 0 | 200 HIST | History | 2 | 0 | 250 GEOL | Geology | 2 | 0 | 80 PHED | Physical Education | 1 | 2 | 350 FREN | French | 2 | 2 | 120 ENGL | English | 2 | 2 | 350 This database only allows the data types: • text • number • currency • Boolean.
✓ 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