Databases: past paper questions
Real questions on databases
The newest 20 of 77 written questions. Open one to see it on the real paper.
- 2210/22 · October/November 2025 · Q7a[1]
State the purpose of a primary key in a database table.
See it on the paper → - 2210/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 → - 2210/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 → - 2210/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 → - 2210/23 · October/November 2025 · Q8a(i)[1]
Give the name of the field that is most appropriate to be the primary key. (a) (i)
See it on the paper → - 2210/23 · October/November 2025 · Q8b[3]
Complete the structured query language (SQL) statement to list equipment not returned. The list must contain only the descriptions and student names. SELECT FROM
See it on the paper → - 2210/21 · May/June 2025 · Q8b[2]
Write the output from the structured query language (SQL) statement: SELECT RouteID, Destination, Time FROM BUS WHERE Driver = "A Patel";
See it on the paper → - 2210/21 · May/June 2025 · Q8c[3]
Complete the SQL statement to display only the destination of the buses that have a return. SELECT
See it on the paper → - 2210/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 → - 2210/22 · May/June 2025 · Q9b[4]
Complete the structured query language (SQL) statement to list only the name, country and population of all the cities in CapitalCity from the continent of Asia. SELECT CapitalCity
See it on the paper → - 2210/22 · October/November 2024 · Q11a[2]
State the number of fields and records in this database table. Fields
See it on the paper → - 2210/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 → - 2210/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 → - 2210/22 · October/November 2024 · Q11d[3]
Give the output that would be produced by the structured query language (SQL) statement: SELECT RoomNo, Type, Guests, Rate$ FROM Booking28 WHERE Mon <> T;
See it on the paper → - 2210/23 · October/November 2024 · Q4[6]
Complete the paragraph about databases. Use terms from the list. You may need to use a term more than once. Some of the terms in the list will not be used. fields comments columns constant key table primary key program records rows scripts database validation variable Database tables consist of and . Rows are . are fie...
See it on the paper → - 2210/23 · October/November 2024 · Q11a[3]
Write the output from this structured query language (SQL) statement. SELECT MtNo, Name FROM BuildStock WHERE WeightKg = 75 ORDER BY PricePerBag;
See it on the paper → - 2210/23 · October/November 2024 · Q11b(i)[2]
Complete this SQL statement to display only the names of all the materials that are out of stock. SELECT FROM (b) (i)
See it on the paper → - 2210/23 · October/November 2024 · Q11b(ii)[2]
Explain how another SQL statement using a different field could be used to display the same information.
See it on the paper → - 2210/21 · May/June 2024 · Q7a[2]
Outline why it is useful to store data in a file.
See it on the paper → - 2210/21 · May/June 2024 · Q9a[1]
State whether any of the given fields would be suitable as a primary key and give a reason for your answer.
See it on the paper →
What examiners said
Candidates who correctly stated that the given table had 18 rows achieved the mark. Some candidates incorrectly stated the number of columns and others incorrectly stated the number of rows including the header row.
— Examiner report, October/November 2023, 2210/22 Q10(a) (Cambridge)
Most candidates correctly identified Code as the primary key field and most of these candidates stated the reason for its choice was that it was a unique identifier.
— Examiner report, October/November 2023, 2210/22 Q10(b) (Cambridge)
Most candidates answered this question well. They correctly identified suitable data types for the given fields.
— Examiner report, October/November 2023, 2210/22 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.