Commdel Consulting Services Application Support Engineer Interview Questions and Answers

An update query to change salary of an employee.

• Use the UPDATE statement with the SET keyword.

• Specify the new salary value.

• Use the WHERE clause to identify the employee to update.

• Example: UPDATE employees SET salary = 60000 WHERE id = 123;

• Make sure to check for any constraints or triggers that may affect the update.