Year 11
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
Loading...
5 Questions
Q1.
Which of the fields above would be most suitable to be the primary key? [1]
Car_reg
Registered_owner
Speed
Q2.
What would be the most appropriate data type for car_reg?
INTEGER
NULL
REAL
Q3.
What type of query should be used to remove a record from a database?
REMOVE
SELECT
UPDATE
Q4.
What would be the output of the following query: SELECT Car_reg WHERE Registered_Owner = "Abeni Barmore";
4
67
YM15PTO
Q5.
What would be the output of the following query: SELECT CaptureID WHERE Speed > 70;
1,2,3,6
4,5
6