IGCSE Computer Science 0478, topic 9
Databases: past paper questions
23 Cambridge IGCSE Computer Science 0478 questions on Databases (9) from 21 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
- 23
- Papers
- 21
- Years
- 2023 to 2026
- Total marks
- 180
- Average per question
- 7.8 marks
- Largest question
- 11 marks
By type: Structured 23
How hard the questions are
- Recall1
- Apply17
- 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
- completeApply21 questions
- stateRecall13 questions
express in clear terms
- giveRecall12 questions
produce an answer from a given source or recall/memory
- explainAnalyse5 questions
set out purposes or reasons / make the relationships between things clear / say why and/or how and support with relevant evidence
- identifyRecall4 questions
name/select/recognise
- writeRecall4 questions
- describeApply2 questions
state the points of a topic / give characteristics and main features
- drawApply1 question
Where the questions come from
By year
- 20263
- 20257
- 20247
- 20236
By session
- May/June12
- Oct/Nov11
By paper
- Paper 223
Questions on this topic
Showing 22 of 23, spread across the years. Open one to write your answer and have it marked.
- Try this questionQuestion 9May/June 2026, paper 21Structured7 marks
A swimming club wants to set up a new database table to store details of the members of the club and the maximum distance each member swam in metres.
- Try this questionQuestion 1Oct/Nov 2025, paper 21Structured4 marks
Four descriptions of structured query language (SQL) keywords and five SQL keywords are given. Draw one line from each description to its matching keyword.
- Try this questionQuestion 10Oct/Nov 2024, paper 21Structured10 marks
A shop that sells cheese has set up a new database table called CheeseStock to store details of the cheeses available for sale. Part of this table is given.
- Try this questionQuestion 9Oct/Nov 2023, paper 21Structured10 marks
A model shop wants to set up a database to help with stock control of the model figures available for sale.
- Try this questionQuestion 9May/June 2026, paper 22Structured10 marks
A database 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.
- Try this questionQuestion 8Oct/Nov 2025, paper 21Structured6 marks
A school has set up a database table SchoolTrip to record details of students that will go on a school trip. State the reason why ParentName is not appropriate as the primary key.
- Try this questionQuestion 11Oct/Nov 2024, paper 22Structured8 marks
A database table called Booking28 stores details of hotel rooms and bookings for the week beginning Monday 7 July 2025.
- Try this questionQuestion 10Oct/Nov 2023, paper 22Structured8 marks
A database table called Horses stores details about the horses kept at a horse sanctuary. State the number of records in this database table.
- Try this questionQuestion 8May/June 2026, paper 23Structured11 marks
A database table OPTION_SUBJECTS stores some data about a number of subjects taken by students in a college.
- Try this questionQuestion 7Oct/Nov 2025, paper 22Structured10 marks
A database table WATERFOWL stores some details of a range of birds found in the UK that live on or near water. The length and wingspan dimensions are in centimetres and the typical lifespan is in years.
- Try this questionQuestion 4Oct/Nov 2024, paper 23Structured6 marks
Complete the paragraph about databases.
- Try this questionQuestion 9Oct/Nov 2023, paper 23Structured11 marks
A sanctuary for pheasants has set up a new database table called PheasantList to store details of the different species of bird at the sanctuary.
- Try this questionQuestion 8Oct/Nov 2025, paper 23Structured5 marks
A school has set up a database table EquipmentLoan to record details of school equipment loaned to students.
- Try this questionQuestion 11Oct/Nov 2024, paper 23Structured7 marks
Building materials are sold in bags. A new database table called BuildStock has been set up to store details about the materials for sale. Part of this table is given.
- Try this questionQuestion 10May/June 2023, paper 21Structured8 marks
A database table called TVRange shows the main features and prices of a range of televisions. Give the name of the field that is most suitable to be the primary key.
- Try this questionQuestion 9May/June 2024, paper 21Structured6 marks
A database table called SoftDrinks stores details of the soft drinks sold by a small shop.
- Try this questionQuestion 10May/June 2023, paper 22Structured6 marks
A music streaming service has a new database table named Songs to store details of songs available for streaming.
- Try this questionQuestion 9May/June 2025, paper 22Structured6 marks
A database table, CapitalCity, stores data about capital cities from around the world.
- Try this questionQuestion 10May/June 2024, paper 22Structured8 marks
A television subscription service has a new database table named Contract to store details of their subscribers’ contracts.
- Try this questionQuestion 10May/June 2023, paper 23Structured8 marks
A database table called Site1 stores details of some holiday homes at a holiday park. The database shows the type of home, number of guests, whether it is privately owned and the weekly rate to hire it.
- Try this questionQuestion 5May/June 2025, paper 23Structured8 marks
A computer store uses a database table COMPONENT to store the stock details of a range of components needed to build computer systems. Complete the table by giving appropriate data types for each field.
- Try this questionQuestion 8May/June 2024, paper 23Structured10 marks
A database table called Hangar1 stores details of a collection of historic aircraft at a museum.