Question

Which command is used to modify existing data in SQL ?

• A. Select
• B. Update
• C. Delete
• D. None of these

Hint:

Remember the three main data-changing commands: `INSERT` to add new rows, `UPDATE` to change existing rows, and `DELETE` to remove rows. `SELECT` is for reading data.

Answer 1

The Correct Option is B

This question is similar to question 27. Step 1: Understand the task. The task is to modify or "change" existing data records (rows) in a table.
Step 2: Differentiate the relevant Data Manipulation Language (DML) commands.

(A) \text{SELECT}: Used to retrieve data from a table.
(B) \text{UPDATE}: Specifically used to modify existing records in a table. This is the correct command.
(C) \text{DELETE}: Used to remove existing records from a table.
The correct command to modify existing data is \text{UPDATE}.