Insert, update, delete
Slide deck
Download slide deck
Lesson details
Key learning points
- 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.
Video
Share with pupils
Loading...
3 Questions
Q1.
What would be the most appropriate data type for car_reg?
INTEGER
NULL
REAL
Q2.
What would be the most appropriate data type for Speed?
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
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