Year 11
Year 11
Swim challenge (Part 2)
Link copied to clipboard
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.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
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