This a tricky SQL Queries for an interview, be prepared to answer this one. ALTER and SET commands can be used to modify an existing entry in the database table. For example, if we wish to replace the work location of the employees residing in Mumbai to Pune, then we can use the query –  ALTER TABLE employees
SET base_location = ‘Pune’
WHERE location = ‘Mumbai’;