What SQL keyword is used to modify existing data in a table?

What SQL keyword is used to modify existing data in a table?

• A. Update
• B. Throwing Exception
• C. While Loop
• D. Xml

Answer: (A)

In SQL, to modify existing data in a table you use the UPDATE statement. It lets you change column values for one or more rows, with a WHERE clause to limit which rows are affected and SET to specify the new values. For example, UPDATE employees SET salary = 60000 WHERE employee_id = 123 updates only that employee’s salary. Without a WHERE, every row would be updated. The other options don’t perform data modification in a table: throwing an exception is error handling in programming, a while loop is a control flow construct, and XML is a data format.

In SQL, to modify existing data in a table you use the UPDATE statement. It lets you change column values for one or more rows, with a WHERE clause to limit which rows are affected and SET to specify the new values. For example, UPDATE employees SET salary = 60000 WHERE employee_id = 123 updates only that employee’s salary. Without a WHERE, every row would be updated. The other options don’t perform data modification in a table: throwing an exception is error handling in programming, a while loop is a control flow construct, and XML is a data format.