Lesson details

Key learning points

  1. In this lesson, we will explore INSERT, UPDATE, and DELETE queries, before being given the opportunity to implement these queries using our music database.

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.
What would be the most appropriate data type for car_reg?
An image in a quiz
INTEGER
NULL
REAL
Correct answer: TEXT
Q2.
What would be the most appropriate data type for Speed?
Correct answer: INTEGER
NULL
REAL
TEXT
Q3.
Which of the following describes the purpose of the following query: INSERT INTO tblSpeeds (Registered_owner, Car_reg, Speed)VALUES ("Sara Bibi","JN03HNM",70);
It would delete record in tblSpeeds that contains Sarah Bibi
Correct answer: It would insert a new, additional record in the database for Sara Bibi
It would update the current record for Sara Bibi and change the speed to 70
This is an invalid query and no changes would be made to the database