Lesson details

Key learning points

  1. 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]
Correct answer: CaptureID
Car_reg
Registered_owner
Speed
Q2.
What would be the most appropriate data type for car_reg?
INTEGER
NULL
REAL
Correct answer: TEXT
Q3.
What type of query should be used to remove a record from a database?
Correct answer: DELETE
REMOVE
SELECT
UPDATE
Q4.
What would be the output of the following query: SELECT Car_reg WHERE Registered_Owner = "Abeni Barmore";
4
67
Correct answer: UT02SKK
YM15PTO
Q5.
What would be the output of the following query: SELECT CaptureID WHERE Speed > 70;
1,2,3,6
Correct answer: 1,3,6
4,5
6

Lesson appears in

UnitComputing / Databases and SQL

Computing