The UNION SQL clause can be used with ____________SELECT clause onlyDELETE and UPDATE clausesUPDATE clause onlyAll of the mentioned

Question 13When must you use a Type I nested query in an UPDATE or DELETE statement?1 pointA non target table has row conditions.A non target table has combined primary key.A non target table has an optional foreign key.A non target table provides columns for the UPDATE statement.

Select the correct answerWhat is the purpose of the SQL UNION operator?OptionsCombines rows from two or more tables, removing duplicatesCombines rows from two or more tables, including duplicatesSorts rows in a tableDeletes rows from a table

2. Describe the differences between the SQL UPDATE and DELETE statements. When would you use one over the other, and what precautions should be taken?

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

Sub-queries can be nested in?UPDATE, DELETE, INSERT and SELECT statements.INSERT statements only.DELETE statements only.UPDATE statements only.