Lesson details

Key learning points

  1. In this lesson, we will use the music database from the previous lesson, 'Database essentials', to write our first SQL commands to access and manipulate the data.

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...

3 Questions

Q1.
Which field would be most suitable to be the Primary Key
Correct answer: CaptureID
Car_Reg
Registered owner
Speed
Q2.
What would be the output of the following query: SELECT Car_reg WHERE Registered_Owner = "Abeni Barmore";
4
67
Correct answer: UT02SKK
YM15PTO
Q3.
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