Skip to content
Try on iPad

Databases: OCR A‑Level Computer Science questions

Every OCR A-Level Computer Science exam question on 1.3.2 Databases, 2021–2025, with its mark scheme and examiner’s report.

Find questions593
Calculations

593 questions

  1. Q6(c)(i)

    June 2025 · Paper 1

    3 marks1.3.2 Databases
    The whole paper ↗
    June 2025 Paper 1, question 6(c)(i): Write an SQL statement to insert this new product into TblSoftware: ProductID: DCC07 Name: DCCCast Type: Sound Price: £89.99 [3]

  2. Q6(c)(ii)

    June 2025 · Paper 1

    5 marks1.3.2 Databases
    The whole paper ↗
    June 2025 Paper 1, question 6(c)(ii): Write an SQL statement to return the Name of products that have a Price that is less than the Price of the product with the Name "DCCDraw". You should use a nes

  3. Q8(a)

    June 2025 · Paper 1

    4 marks1.3.2 Databases
    The whole paper ↗
    June 2025 Paper 1, question 8(a): Orla is considering using a flat file database to store data about candidates, and the subjects and quizzes they sit. Explain the limitations of using flat file

  4. Q8(b)

    June 2025 · Paper 1

    3 marks1.3.2 Databases
    The whole paper ↗
    June 2025 Paper 1, question 8(b): Due to the limitations of flat file databases, Orla decides to create a relational database containing these four tables: • TblCandidate – Stores data about the

  5. Q8(c)(i)

    June 2025 · Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2025 Paper 1, question 8(c)(i): State two requirements for a database to be in Second Normal Form (2NF). 1 2 [2]

  6. Q8(c)(ii)

    June 2025 · Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2025 Paper 1, question 8(c)(ii): State two requirements for a database to be in Third Normal Form (3NF). 1 2 [2]

  7. Q3(a)

    June 2025 · AS Paper 1

    4 marks1.3.2 Databases
    The whole paper ↗
    June 2025 AS Paper 1, question 3(a): Identify two data methods that Ben could use to capture the data and identify a benefit of each. METHOD 1 Method Benefit METHOD 2 Method Benefit [4]

  8. Q7

    June 2024 · Paper 1

    9 marks1.3.2 Databases
    The whole paper ↗
    June 2024 Paper 1, question 7: 7* Rosa has recently opened a new leisure centre. Currently she has 150 members, however, she is estimating that this will increase to around 10 000 members. Ro

  9. Q4(f)(i)

    June 2023 · Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2023 Paper 1, question 4(f)(i): Write an SQL statement to delete all records from the table TblAccessLog for users who have a UserType of "NotNeeded". [2]

  10. Q4(f)(ii)

    June 2023 · Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2023 Paper 1, question 4(f)(ii): State two requirements for a database to be in First Normal Form (1NF). 1 2 [2]

  11. Q4(f)(iii)

    June 2023 · Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2023 Paper 1, question 4(f)(iii): Explain why the structure of TblAccessLog means that this database is not in First Normal Form (1NF). [2]

  12. Q4(a)

    June 2023 · AS Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2023 AS Paper 1, question 4(a): State two benefits of using a relational database instead of a flat file database. 1 2 [2]

  13. Q4(b)

    June 2023 · AS Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2023 AS Paper 1, question 4(b): One customer can order as many different products as they like in the same order. A customer can also place as many orders as they like. One product can be orde

  14. Q4(c)(i)

    June 2023 · AS Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2023 AS Paper 1, question 4(c)(i): State the difference between a primary key and a foreign key. [2]

  15. Q4(c)(ii)

    June 2023 · AS Paper 1

    1 mark1.3.2 Databases
    The whole paper ↗
    June 2023 AS Paper 1, question 4(c)(ii): State one foreign key in the order table. [1]

  16. Q4(c)(iii)

    June 2023 · AS Paper 1

    1 mark1.3.2 Databases
    The whole paper ↗
    June 2023 AS Paper 1, question 4(c)(iii): State why CustomerID would not make a suitable primary key in the order table. [1]

  17. Q2(a)(i)

    June 2022 · Paper 1

    1 mark1.3.2 Databases
    The whole paper ↗
    June 2022 Paper 1, question 2(a)(i): State what is meant by the term ‘primary key’. [1]

  18. Q2(a)(ii)

    June 2022 · Paper 1

    2 marks1.3.2 Databases
    The whole paper ↗
    June 2022 Paper 1, question 2(a)(ii): Identify the foreign key used in the database and the table name where this is a foreign key. Foreign Key Table Name [2]

  19. Q2(b)

    June 2022 · Paper 1

    5 marks1.3.2 Databases
    The whole paper ↗
    June 2022 Paper 1, question 2(b): The Adverts field indicates if customers will be shown adverts. true indicates that customers will be shown adverts, and false indicates that adverts are not sh

  20. Q2(c)(i)

    June 2022 · Paper 1

    3 marks1.3.2 Databases
    The whole paper ↗
    June 2022 Paper 1, question 2(c)(i): Identify one method of capturing a new customer’s personal data, describing why this method is suitable. Method Suitability [3]
All 29 questions on Databases, as a list
  1. June 2025, Paper 1, Q6(c)(i) (3 marks): Write an SQL statement to insert this new product into TblSoftware: ProductID: DCC07 Name: DCCCast Type: Sound Price: £89.99 [3]
  2. June 2025, Paper 1, Q6(c)(ii) (5 marks): Write an SQL statement to return the Name of products that have a Price that is less than the Price of the product with the Name "DCCDraw". You should use a nes
  3. June 2025, Paper 1, Q8(a) (4 marks): Orla is considering using a flat file database to store data about candidates, and the subjects and quizzes they sit. Explain the limitations of using flat file
  4. June 2025, Paper 1, Q8(b) (3 marks): Due to the limitations of flat file databases, Orla decides to create a relational database containing these four tables: • TblCandidate – Stores data about the
  5. June 2025, Paper 1, Q8(c)(i) (2 marks): State two requirements for a database to be in Second Normal Form (2NF). 1 2 [2]
  6. June 2025, Paper 1, Q8(c)(ii) (2 marks): State two requirements for a database to be in Third Normal Form (3NF). 1 2 [2]
  7. June 2025, AS Paper 1, Q3(a) (4 marks): Identify two data methods that Ben could use to capture the data and identify a benefit of each. METHOD 1 Method Benefit METHOD 2 Method Benefit [4]
  8. June 2024, Paper 1, Q7 (9 marks): 7* Rosa has recently opened a new leisure centre. Currently she has 150 members, however, she is estimating that this will increase to around 10 000 members. Ro
  9. June 2023, Paper 1, Q4(f)(i) (2 marks): Write an SQL statement to delete all records from the table TblAccessLog for users who have a UserType of "NotNeeded". [2]
  10. June 2023, Paper 1, Q4(f)(ii) (2 marks): State two requirements for a database to be in First Normal Form (1NF). 1 2 [2]
  11. June 2023, Paper 1, Q4(f)(iii) (2 marks): Explain why the structure of TblAccessLog means that this database is not in First Normal Form (1NF). [2]
  12. June 2023, AS Paper 1, Q4(a) (2 marks): State two benefits of using a relational database instead of a flat file database. 1 2 [2]
  13. June 2023, AS Paper 1, Q4(b) (2 marks): One customer can order as many different products as they like in the same order. A customer can also place as many orders as they like. One product can be orde
  14. June 2023, AS Paper 1, Q4(c)(i) (2 marks): State the difference between a primary key and a foreign key. [2]
  15. June 2023, AS Paper 1, Q4(c)(ii) (1 mark): State one foreign key in the order table. [1]
  16. June 2023, AS Paper 1, Q4(c)(iii) (1 mark): State why CustomerID would not make a suitable primary key in the order table. [1]
  17. June 2022, Paper 1, Q2(a)(i) (1 mark): State what is meant by the term ‘primary key’. [1]
  18. June 2022, Paper 1, Q2(a)(ii) (2 marks): Identify the foreign key used in the database and the table name where this is a foreign key. Foreign Key Table Name [2]
  19. June 2022, Paper 1, Q2(b) (5 marks): The Adverts field indicates if customers will be shown adverts. true indicates that customers will be shown adverts, and false indicates that adverts are not sh
  20. June 2022, Paper 1, Q2(c)(i) (3 marks): Identify one method of capturing a new customer’s personal data, describing why this method is suitable. Method Suitability [3]
  21. June 2022, Paper 1, Q2(c)(ii) (2 marks): Sometimes the company may need to move or backup its data they hold about customers. Identify two methods of exchanging data with other computer systems. 1 2 [2
  22. June 2022, Paper 1, Q2(d)(i) (2 marks): Describe what is meant by a transaction being durable. [2]
  23. June 2022, Paper 1, Q2(d)(ii) (1 mark): Give one way that durability can be achieved for a completed transaction. [1]
  24. June 2022, Paper 1, Q2(d)(iii) (3 marks): Explain how record locking can be used to ensure that the ACID principle of isolation is achieved when carrying out multiple transactions. [3]
  25. June 2022, Paper 1, Q2(d)(iv) (1 mark): Give one disadvantage of using record locking. [1]
  26. November 2021, Paper 1, Q1(d)(i) (2 marks): State what is meant by the term ‘primary key’, identifying the primary key in the table above. [2]
  27. November 2021, Paper 1, Q1(d)(ii) (4 marks): Write the SQL statement that would show only the CustomerID and Surname fields for customers with the Title “Miss” or “Mrs”. [4]
  28. November 2021, Paper 1, Q1(d)(iii) (2 marks): Describe one problem that would arise with the flat file database structure if a customer wanted to insure more than one car at the same time. [2]
  29. November 2021, Paper 1, Q1(d)(iv) (5 marks): Describe how the flat file database structure could be altered to efficiently allow each customer to insure multiple cars at the same time. (You may assume each

Questions, mark schemes and examiner’s reports are © OCR, from their published past papers. Plumi isn’t affiliated with any exam board. Want whole papers? Full past papers.

Rather write your answers by hand on iPad? Plumi marks them against the same mark schemes.