Write an SQL query to list the names and house points of pupils in form 10A.
From Paper 2: Computing concepts
11.22 marks
Write an SQL statement to add 5 house points to pupil 104.
From Paper 2: Computing concepts
11.32 marks
Write an SQL statement to insert a new pupil: 105, Zara, 10B, 0.
From Paper 2: Computing concepts
11.42 marks
Explain what is meant by a primary key and a foreign key.
Score 0 / 9 · 0 of 4 marked
This paper is written by Plasmo in the style of the AQA GCSE Computer Science exam. It is not a past paper and is not produced or endorsed by the exam board.