rect 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 Name = 'Lisa Green';DELETE FROM Employees WHERE EmployeeID = '4';DELETE FROM Employees WHERE Department = 'Finance';

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

Problem StatementIn a company's Employee Management System, a database table named "Employees" that stores information about employees, including their EmployeeID, EmployeeName, Department, and Salary.The HR department needs a mechanism to delete employee records from the system when an employee leaves the company or for any other valid reason. To address this requirement, you are tasked with creating a stored procedure named "DeleteEmployee," which takes an EmployeeID as input and deletes the corresponding employee record from the "Employees" table.The following table is already created, and the records are inserted into the table.TABLE: Employees EmployeeID INT PRIMARY KEY, EmployeeName VARCHAR(50), Department VARCHAR(50), Salary DECIMAL(10, 2)Prepopulated Records:Input format :The input records are already prepopulated, as given in the problem statement.Output format :The stored procedure deletes the employee record based on the provided EmployeeID.The output should display the employee details after deletion as shown below.EmployeeID EmployeeName Department Salary1 John Doe IT 60000.002 Jane Smith HR 55000.003 Bob Johnson Marketing 70000.004 Alice Williams Finance 80000.00EmployeeID EmployeeName Department Salary1 John Doe IT 60000.003 Bob Johnson Marketing 70000.004 Alice Williams Finance 80000.00Refer to the sample output for the column headers.

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@EmployeeID INTASBEGIN DELETE FROM Employees WHERE EmployeeID = @Employe' at line 2

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;