Which keywords are used to update data in a table?

• A. DELETE and FROM
• B. UPDATE and SET
• C. INSERT and VALUES
• D. ALTER and UPDATE

Answer: (B)

Updating data in a table is done with the UPDATE statement, using SET to assign new values to one or more columns. The SET clause specifies what changes to make, and the WHERE clause limits which rows are affected. If you omit the WHERE clause, every row in the table would be updated, which is usually not desired. The other options relate to different tasks: removing rows, adding new rows, or changing the table structure. So using UPDATE together with SET is the correct way to modify existing data.