plumiData Definition Language (DDL) and Data Manipulation Language (DML): CAIE A‑Level Computer Science questions
Every CAIE A-Level Computer Science exam question on 8.3 Data Definition Language (DDL) and Data Manipulation Language (DML), June 2024 and the specimen papers, with its mark scheme and examiner’s report.
Paper
All papers
Exam
All years
Calculations
Q6(c)(i)
The whole paper ↗
Q6(c)(ii)
The whole paper ↗Q3(b)(i)
The whole paper ↗
Q3(b)(ii)
The whole paper ↗
All 4 questions on Data Definition Language (DDL) and Data Manipulation Language (DML), as a list
- June 2024, Paper 1, Q6(c)(i) (2 marks): The database FARMING has a second table created named PLAYER that has the primary key PlayerID. The field PlayerID in EVENT needs to be set up as a foreign key
- June 2024, Paper 1, Q6(c)(ii) (3 marks): Write an SQL script to return the number of events that each player has completed. [3]
- Specimen, Paper 1, Q3(b)(i) (4 marks): Write an SQL script to display the first name and second name of all staff members working on 22/05/2020. [4]
- Specimen, Paper 1, Q3(b)(ii) (3 marks): Write an SQL script to count the number of people working on the morning of 26/05/2020. [3]
Questions, mark schemes and examiner’s reports are © Cambridge University Press & Assessment, from their published past papers. Plumi isn’t affiliated with any exam board. Want whole papers? Full past papers.
Rather write your answers by hand on iPad? Plumi marks them against the same mark schemes.