Databases: past paper questions
Real questions on databases
The newest 20 of 24 written questions. Open one to see it on the real paper.
- 0984/21 · May/June 2026 · Q9a(i)[1]
State why MemberName would not be appropriate for a primary key.
See it on the paper → - 0984/21 · May/June 2026 · Q9a(ii)[1]
Give the name of the most appropriate field for the primary key.
See it on the paper → - 0984/21 · May/June 2026 · Q9b[2]
Complete the table to identify the most appropriate data type for these fields in the table SWIMMERS. Each data type must be different. field data type Distance Date MemberID
See it on the paper → - 0984/21 · May/June 2026 · Q9c[3]
(c) Complete the structured query language (SQL) statement to display only the names of the members who swam a distance of 1500 metres or more. SELECT .......... FROM .......... WHERE .......... Turn over
See it on the paper → - 0984/22 · May/June 2026 · Q9a[4]
Adatabase table CAR_PARTS stores details of car parts that a business has in stock. Complete the table by giving the most appropriate data types for each field. Only the data types: text, character, Boolean, integer, real and date/time are available in this database. field data type description unique code to identify...
See it on the paper → - 0984/22 · May/June 2026 · Q9b[4]
(b) Complete the structured query language (SQL) statement to list only the part ID, type of car and the quantity in stock of all the car parts that are brake pads. SELECT .......... FROM .......... WHERE, ..........
See it on the paper → - 0984/22 · May/June 2026 · Q9c[2]
Describe one reason why the InStock field is not needed in the table. Turn over
See it on the paper → - 0984/22 · October/November 2025 · Q7a[1]
State the purpose of a primary key in a database table.
See it on the paper → - 0984/22 · October/November 2025 · Q7b[2]
Complete the table for each of the given data types, to identify one field from the table WATERFOWL that is most likely to use it. Each field must be different. Data type Field Boolean Integer Text Real
See it on the paper → - 0984/22 · October/November 2025 · Q7c[3]
Give the output that would be produced by the structured query language (SQL) statement: SELECT Species, Length, Wingspan FROM WATERFOWL WHERE Family = "Swan" ORDER BY Lifespan;
See it on the paper → - 0984/22 · October/November 2025 · Q7d[4]
Complete the SQL statement to list only the species, family and lifespan of all waterfowl whose typical lifespan is at least 10 years, sorted in order of species. SELECT
See it on the paper → - 0984/22 · May/June 2025 · Q9a[2]
Complete the table by writing one appropriate field from CapitalCity for each data type. Each field must be different. Data type Field Boolean integer real text
See it on the paper → - 0984/22 · October/November 2024 · Q11b[1]
State the reason why the Type field would not be suitable as a primary key.
See it on the paper → - 0984/22 · October/November 2024 · Q11c[2]
The database uses only the data types: • • • • • • alphanumeric character Boolean integer real date/time. Complete the table to show the fields that could have the given data types. Only one field name is required in each box and each field name must be different. Field Data type alphanumeric Boolean real integer
See it on the paper → - 0984/22 · May/June 2024 · Q10a[1]
Identify the field that will be the most appropriate primary key for this table.
See it on the paper → - 0984/22 · May/June 2024 · Q10d[2]
Complete this SQL statement to find the contract numbers of the subscribers that take both the news and sports services. SELECT FROM Contract
See it on the paper → - 0984/21 · May/June 2023 · Q10a[2]
Give the name of the field that is most suitable to be the primary key. State the reason for this choice. Field Reason
See it on the paper → - 0984/21 · May/June 2023 · Q10c[4]
Complete the structured query language (SQL) query to return the television (TV) code, screen size and price of all Smart TVs in the database table. SELECT TVCode, , TVRange WHERE SmartTV = ;
See it on the paper → - 0984/21 · May/June 2022 · Q6a[1]
State the number of fields that are in the table GAMES.
See it on the paper → - 0984/21 · May/June 2022 · Q6b[1]
State one important fact that must be true for a field to be a primary key.
See it on the paper →
What examiners said
This question was generally answered well, with most candidates able to correctly identify at least two fields to match the given data types.
— Examiner report, May/June 2025, 0984/22 Q9(a) (Cambridge)
Most candidates were able to identify the correct field for the primary key and gave a valid reason.
— Examiner report, May/June 2023, 0984/21 Q10(a) (Cambridge)
Most candidates achieved three or more of the marks available. A few candidates did not copy the field names correctly. A few candidates did not refer back to the previous question when selecting the response to the WHERE part of the question.
— Examiner report, May/June 2023, 0984/21 Q10(c) (Cambridge)
Past papers, syllabus and examiner reports © UCLES (Cambridge University Press & Assessment). Questions are matched to topics from the official syllabus. AssessPro is independent and not endorsed by Cambridge.