Insert, update, delete

Computing

Databases and SQL

tblSpeeds

What would be the most appropriate data type for car_reg?

What would be the most appropriate data type for Speed?

It would delete record in tblSpeeds that contains Sarah Bibi

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

Which of the following describes the purpose of the following query: INSERT INTO tblSpeeds (Registered_owner, Car_reg, Speed)VALUES ("Sara Bibi","JN03HNM",70);

This lesson will soon be taken down.

Insert, update, delete

Lesson outcome