Swim challenge (Part 2)
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]
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707156817%2Fg4qwkvrfflnkshshk3qx.png&w=1080&q=75)
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