Consider the following SQL statement:SELECT employee_id FROM employeesUNIONSELECT employee_id FROM former_employees;What does this statement do?Returns the employee IDs of all current employees.Returns the employee IDs of all former employees.Returns the employee IDs of both current and former employees, eliminating duplicates.Returns the employee IDs of both current and former employees, including duplicates.

Consider the following SQL statement:SELECT employee_id FROM employeesUNIONSELECT employee_id FROM former_employees;What does this statement do

Returns the employee IDs of all current employees.Returns the employee IDs of all former employees.Returns the employee IDs of both current and former employees, eliminating duplicates.Returns the employee IDs of both current and former employees, including duplicates.Next

Suppose we wish to find the ID’s of the employees that are managed by people who are managed by the employee with ID 123. Here are two possible queries:I.SELECT ee.empIDFROM Emps ee, Emps ffWHERE ee.mgrID = ff.empID AND ff.mgrID = 123;II.SELECT empIDFROM Emps WHERE mgrID IN(SELECT empID FROM Emps WHERE mgrID = 123);Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?II onlyI onlyBoth I and IINeither I nor II

What will the following SQL query return? SELECT e.name, d.department_name FROM employees e LEFT JOIN departments d ON e.department_id = d.department_id;Select one:a. Names of employees along with the names of their departments.b. Names of employees along with the IDs of their departments in descending order.c. Names of employees along with the IDs of their departments.d. Names of employees along with their department names.

employee_id Name Salary1001 Annie 60001009 Ross 45001018 Zeith 7000above are the Employee table details.select employee_id from employee order by employee_id desc;Which of the following output will be true?