Which SQL operation is used specifically to modify existing rows in a database table?

Which SQL operation is used specifically to modify existing rows in a database table?

• A. Select
• B. Create
• C. Update
• D. Delete

Answer: (C)

In SQL, the operation used to modify existing rows is UPDATE. It changes values in one or more columns for rows that already exist in a table, without adding or removing rows. You specify which rows to change with a WHERE clause, and you set new values with the SET clause, for example: UPDATE employees SET salary = salary * 1.05 WHERE performance = 'Excellent'; This demonstrates updating data in place across matching rows. In contrast, SELECT retrieves data, CREATE builds new tables or structures, and DELETE removes rows from a table.

In SQL, the operation used to modify existing rows is UPDATE. It changes values in one or more columns for rows that already exist in a table, without adding or removing rows. You specify which rows to change with a WHERE clause, and you set new values with the SET clause, for example: UPDATE employees SET salary = salary * 1.05 WHERE performance = 'Excellent'; This demonstrates updating data in place across matching rows.

In contrast, SELECT retrieves data, CREATE builds new tables or structures, and DELETE removes rows from a table.