Ace the A Level Computer Science OCR 2025 – Code Your Way to Success!

Question: 1 / 400

Which SQL statement is used to modify existing records in a database?

SQL INSERT INTO

SQL UPDATE

The correct answer is indeed the SQL UPDATE statement. This command is specifically designed for modifying existing records within a database. When you need to change data in specific columns of rows that already exist, you use the UPDATE command, along with a WHERE clause to specify which records should be altered, ensuring that only targeted data is affected.

The other statements serve different purposes. SQL INSERT INTO is used for adding new records to a table, while SQL DELETE is used for removing records from a table. SQL SELECT, on the other hand, is for retrieving data from one or more tables without making any modifications to the records. Each of these serves a distinct function in database management, but when it comes to modifying existing data, SQL UPDATE is the appropriate choice.

Get further explanation with Examzify DeepDiveBeta

SQL DELETE

SQL SELECT

Next Question

Report this question

Download Ace the A Level Computer Science OCR 2025 – Code Your Way to Success! PDF Study Guide
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy