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

To delete rows from the SALES table, where the PROMO_NAME column in thePROMOTIONS table has either 'blowout sale' or 'everyday low price' as values. Which DELETE statements are valid? (Choose all that apply.)Select one or more:a.DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price');b.DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale'OR promo_name = 'everyday low price');c.DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price');d.DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN ('blowout sale','everyday low price'));

What happens if the DELETE command is used without a WHERE clause?AOnly the first row will be deletedBAll rows in the table will be deletedCNo rows to delete

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

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

Which SQL statement is used to delete all records from a table?OptionsDELETE ALLREMOVEDROPTRUNCATE