Question

In SQL which command is used to change data in a table ?

• A. Update
• B. Insert
• C. Browse
• 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.

Answer 1

The Correct Option is A

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{UPDATE}: This command is specifically used to modify existing records in a table. For example, `UPDATE customers SET city = 'New York' WHERE customerId = 1;`. This fits the description.
(B) \text{INSERT}: This command is used to add new records to a table.
(C) \text{Browse}: This is not a standard SQL command for data manipulation. Data is viewed using the `SELECT` command.
The correct command to change existing data is \text{UPDATE}.