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';

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;

Which SQL command is used to delete a table named "Employees" along with its data?radio_button_uncheckedREMOVE TABLE Employeesradio_button_uncheckedDROP TABLE Employeesradio_button_uncheckedDELETE TABLE Employeesradio_button_uncheckedERASE TABLE Employees

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?Select one:a.DELETE ROW FirstName='Peter' FROM Personsb.DELETE FirstName='Peter' FROM Personsc.DELETE 'Peter' OF FirstName FROM Personsd.DELETE FROM Persons WHERE FirstName = 'Peter'e.All of the answers are correct

An emp table contains fields employ name, desig and salary. How do you drop column salary?Select one:a.delete from emp where column = salary;b.alter table emp drop column salary;c.alter table emp delete column salary;d.alter table emp delete salary;

Select the correct answer What is the SQL keyword used to remove a table from the database?OptionsDELETE TABLEREMOVE TABLEDROP TABLEERASE TABLE