Lesson 3 of 5
These resources will be removed by the end of the Spring Term 2026.
Start using our brand new teaching resources now. Designed by teachers and subject experts, with real classrooms in mind.
The older resources below were created for lockdown learning during the pandemic and are not designed for classroom teaching.
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.
Loading...
3 Questions
Q1.What would be the most appropriate data type for car_reg?
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?
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);
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