Select the correct answerConsider a database table called "Employees" with the following columns:  EmployeeID (integer)  Name (text)  Age (integer)  Department (text)Sample data:What is the SQL query to update the age of the employee with EmployeeID 3 to 29?OptionsUPDATE Employees SET Age = 29 WHERE EmployeeID = 3;UPDATE Employees SET Age = 29 WHERE Name = 'Mike Davis';UPDATE Employees SET Age = 29 WHERE Age = 28;UPDATE Employees SET Age = 29;

Select the correct answerConsider a database table called "Employees" with the following columns:  EmployeeID (integer)  Name (text)  Age (integer)  Department (text)Sample data:What is the SQL query to delete the employee with EmployeeID 4 from the table?OptionsDELETE FROM Employees WHERE EmployeeID = '4';DELETE FROM Employees WHERE EmployeeID = 4;DELETE FROM Employees WHERE Name = 'Lisa Green';DELETE FROM Employees WHERE Department = 'Finance';

You have a table named pamperedPets. The table tracks the pets of customers by pet_id. There is a record for a pet whose pet_id is 10. You need to change the value of the age field from 7 to 8. You open MySQL Workbench and begin typing your query:UPDATE pamperedPets SET age = 8WHERE pet_id = 10;You execute the statement. You then execute a SELECT statement and discover that the record has not been updated. What must you do to update the table?1 pointChange the query to UPDATE pamperedPets WHERE pet_id=10 SET age=8Change the query to UPDATE pamperedPets SET age=8 WHERE pet_id IN (SELECT pet_id FROM pamperedPets WHERE pet_id=10)Change the query to UPDATE pamperedPets SET age=8You should execute the SET SQL_SAFE_UPDATES=0 statement.

What is the correct SQL command to change the data type of a column named age in a table named users from INT to VARCHAR(3)?  *1 pointMODIFY TABLE users ALTER COLUMN age VARCHAR(3)ALTER TABLE users MODIFY age VARCHAR(3)ALTER TABLE users CHANGE COLUMN age VARCHAR(3)ALTER TABLE users ALTER COLUMN age TO VARCHAR(3)

Given a table salary, such as the one below, that has m=male and f=femalevalues. Swap all f and m values (i.e., change all f values to m and vice versa)with a single update statement and no intermediate temp table.Note : You must write a single update statement, DO NOT write any selectstatement for this problem.Example:idnamesexsalary1Am25002Bf15003Cm55004Df500After running your update statement, the above salary table should have thefollowing rows:idnamesexsalary1Af25002Bm15003Cf55004Dm500Optionsupdate salaryset sex = if(sex = 'm', 'f', 'm');update salaryset sex = if(sex = 'm', 'm', 'm');update nameset salary = if(name = 'm', 'f', 'm');update salaryset sex = if(sex != 'f', 'm', 'm');

Which SQL statement is used to update data in a database?Question 15Answera.UPDATEb.SETc.CHANGEd.MODIFY