Selected practice set

Databases

Relational database structure and SQL for Paper 2.

24 questions≈ 20 minutesPrintable worksheet →
Start questions
Subtopics in this topic (3)
  • Fields, records and keys
  • Data types and table design
  • SQL selection and aggregation

Unofficial practice covering selected topics.

Practice scope
All topics
Computer ScienceDatabases
Choose a question to begin

24 original questions · 0 derived marking activities. Unofficial selected-topic practice, not a complete syllabus or rights-cleared exam-board material.

Review status: an AI-assisted content check is recorded for 24 of 24 activities in this topic. This is not independent teacher approval, exam-board endorsement or rights clearance, and it does not certify syllabus alignment.

Active scope: All available content

Practice diagnosis
Practice diagnosisStart with a short attempt, then self-mark

Open one question, write your working, then reveal the marking points. A clearer recommendation appears after you self-mark a few questions.

0%completionNot startedself-marked accuracyReady when you areself-marked progress
More filters
View
Revision Ladder

24 of 24 activities match

Self-assessedSelf-mark your first attempt
Set total49

This is a self-study tool, not official marking or a predicted Cambridge IGCSE grade.

Session report
Session report

Priority: finish the attempt

Complete more questions and self-mark them to get a sharper diagnosis.

Marked activities
0/24
Self-marked accuracy
Not started
Self-marked progress
Ready when you are
Progress is saved on this device. Sign in to sync across devices.

Databases: translate a question into a precise query

Begin with the table structure: a field describes an attribute and a record contains values for one entry. A query selects the records and fields needed for a purpose. Check your examination-year syllabus and the SQL conventions expected in class; a working query in one database system is not automatically the required exam notation.

A method to practise

  • Identify a suitable primary key: it must uniquely identify a record, so a person's name alone is often unsuitable.
  • Separate the fields being displayed from the condition selecting records.
  • Trace a query against a small table by hand before deciding whether its result matches the question.

Original worked illustration

A table Books contains BookID, Title and Price. Select titles priced below 10.

  1. The displayed field is Title, the source table is Books and the condition is Price < 10.
  2. A simple SQL query is: SELECT Title FROM Books WHERE Price < 10;
  3. A book priced exactly 10 is excluded. Use <= only if the question asks for 10 or less.

Common mistake to avoid

Do not confuse a primary key with a sort order or assume that a field called Name is unique. Check boundary values in selection conditions, because a single inequality can change the returned records.

Continue with a relevant topic

Cambridge syllabus and examination-year guidance. Choose your examination year; topic coverage and assessment requirements can change.

SubjectScout editorial revision: 23 October 2026. Original learning guidance, not an official examination answer or endorsed resource.

Timed practice on this topic

What do you need help with?

No payment now. Requests are reviewed; personal tutor matching is currently for adults only.

Example question and marking points

Explain one advantage of a relational database over a single flat-file database for storing a school's student and course records.

  1. Explains that a relational database stores data in separate, linked tables instead of one large repeated table.
  2. Explains that this avoids duplicating the same student details for every course they take, reducing storage space and the risk of inconsistent data.

Check your reasoning: Well-designed linked tables can reduce repeated facts and update inconsistencies. Merely using a relational database does not automatically eliminate duplication; suitable keys and schema design are needed.

Original SubjectScout practice, not an official past-paper question.

Before you practise

Questions learners ask about this practice

Are these official Cambridge IGCSE questions?

No. These are original SubjectScout practice questions for Databases. They are not official past-paper questions or endorsed material.

What does this Computer Science practice page include?

It includes selected topic questions, marking points, and feedback prompts designed to help learners practise before requesting teacher support.

Can I request a teacher for this exact topic?

Yes. Tell SubjectScout the subject, exact topic, level and deadline, and the team will try to match you with a suitable verified teacher.

More practice in this subject