A Level Computer Science 9618, topic 8.2
Database Management Systems (DBMS): past paper questions
10 Cambridge A Level Computer Science 9618 questions on Database Management Systems (DBMS) (8.2) from 10 papers, 2023 to 2026. Open the paper or try a question free.
Practising builds a set from this topic, free with an account. One question opens straight away, with no account.
- Questions
- 10
- Papers
- 10
- Years
- 2023 to 2026
- Total marks
- 154
- Average per question
- 15.4 marks
- Largest question
- 19 marks
By type: Structured 10
How hard the questions are
- Recall0
- Apply5
- Analyse5
- Not banded0
Derived from the command word Cambridge prints in each question, banded by a fixed table beside the syllabus's own definitions. A question printing no command word is unbanded: unknown, not middling.
Command words
- writeRecall8 questions
write an answer in a specific way
- completeApply6 questions
add information to an incomplete diagram or table
- describeApply5 questions
state the points of a topic / give characteristics and main features
- explainAnalyse5 questions
set out purposes or reasons / make the relationships between things clear / say why and/or how and support with relevant evidence
- giveRecall2 questions
produce an answer from a given source or recall/memory
- identifyRecall2 questions
name/select/recognise
- nameRecall2 questions
- stateRecall2 questions
express in clear terms
- defineRecall1 question
give precise meaning
- drawApply1 question
draw a line to match a term with a description
Where the questions come from
By year
- 20261
- 20254
- 20242
- 20233
By session
- May/June6
- Oct/Nov4
By paper
- Paper 110
Questions on this topic
Showing 10 of 10, spread across the years. Open one to write your answer and have it marked.
- Try this questionQuestion 3May/June 2026, paper 12Structured16 marks
A computer game developer stores data about a computer game in a database. The database has three entities: • the users, who are called players • the characters that users can create • the groups that users can create and allow characters to join.
- Try this questionQuestion 4Oct/Nov 2025, paper 12Structured10 marks
A relational database, SHIPPING, stores data about the ships in a company and the containers that are carried on the ships.
- Try this questionQuestion 4Oct/Nov 2024, paper 13Structured19 marks
A company makes ice cream and sells it to shops. The ice cream is made in batches: a large quantity of one type and flavour of ice cream that is then split into smaller quantities for sale.
- Try this questionQuestion 2Oct/Nov 2023, paper 12Structured11 marks
State what is meant by the following terms in a relational database model.
- Try this questionQuestion 5Oct/Nov 2025, paper 13Structured16 marks
A company creates a relational database to store data about its customers. The database, REVIEWS, stores data about the customers, products, complaints and staff.
- Try this questionQuestion 6May/June 2024, paper 11Structured15 marks
A company is developing a website that will allow users to create an account and then play a quiz every day. The data about the users and the quizzes are stored in a database. A user must select a unique username and enter a valid email address to create an account.
- Try this questionQuestion 2May/June 2023, paper 11Structured16 marks
An organisation uses a database to store data about the types of bird that people have seen. The database is managed using a Database Management System (DBMS). State what is meant by a data dictionary and give one example of an item typically found in a data dictionary.
- Try this questionQuestion 5May/June 2025, paper 12Structured16 marks
An online game has a database that stores data about users and the characters each user creates in the game. Each user can create multiple characters and purchase multiple items for each character.
- Try this questionQuestion 2May/June 2023, paper 12Structured17 marks
A horse riding school uses a database, Lessons, to store data about lesson bookings. This database is created and managed using a Database Management System (DBMS). The table contains names and descriptions of DBMS features and tools.
- Try this questionQuestion 6May/June 2025, paper 13Structured18 marks
A shop sells pens to customers. Customers place an order with the shop and collect the items the next day. The shop uses a database to store the information about the orders.