Data Definition Language (DDL) and Data Manipulation Language (DML): past paper questions

Where the questions come from

• Question 4May/June 2026, paper 11Structured18 marks

  A shop allows customers to pay to borrow toys. The shop uses a database to record information about the customers and the toys they have borrowed.

  Try this question
• Question 2Oct/Nov 2025, paper 11Structured13 marks

  A relational database, WORKEXPERIENCE, stores data about students and the companies where they complete work experience.

  Try this question
• Question 2Oct/Nov 2024, paper 11Structured17 marks

  A shop repairs electronic devices, for example mobile phones and tablet computers. The shop owner stores the data about the repairs using a file-based approach.

  Try this question
• Question 3Oct/Nov 2023, paper 11Structured11 marks

  A shop manager has designed a relational database to store customer orders.

  Try this question
• Question 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 question
• Question 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 question
• Question 6Oct/Nov 2024, paper 12Structured12 marks

  A company uses a relational database to store data about its customers, employees and the individual repair jobs that customers have booked. Explain the benefits of using a relational database instead of a file-based approach.

  Try this question
• Question 3Oct/Nov 2023, paper 13Structured18 marks

  A company sells online Computer Science courses to students in different countries. The courses are stored on a public cloud. Explain why the company uses a public cloud to store these courses.

  Try this question
• Question 4May/June 2026, paper 13Structured17 marks

  A database needs designing for a school library. The library stores data about books including the author, title, category and number of pages. The library will also store data about the students and the books they have borrowed.

  Try this question
• Question 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 question
• Question 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 question
• Question 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 question
• Question 5May/June 2025, paper 11Structured13 marks

  A company builds and sells furniture to customers. The company stores data about customers, their payment cards and their furniture orders in a database.

  Try this question
• Question 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 question
• Question 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 question
• Question 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 question
• Question 4May/June 2024, paper 12Structured11 marks

  An assessment board wants to store the marks students achieved in exams in a database named RECORDS.

  Try this question
• Question 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.

  Try this question
• Question 4May/June 2024, paper 13Structured14 marks

  A theatre wants to use a database to store data about the shows that are scheduled, their customers and the seats that the customers have booked. In the theatre: • Each show can take place on multiple dates.

  Try this question