What does this query primarily achieve? Question 3Answera.Retrieves only departments without any employees.b.Retrieves all departments, including those without assigned employees.c.Retrieves only employees without a designated department.d.Retrieves an error due to the improper use of the RIGHT JOIN.

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.

Evaluate below sql statement SELECT emp_name, department FROM employees WHERE department = 'HR' UNION SELECT contractor_name, department FROM contractors WHERE department = 'IT';Select one:a. Retrieves the names of all employees and contractors from the HR and IT departments.b. Retrieves the names of employees from the HR department and all contractors.c. Retrieves the names of employees and contractors from the HR and IT departments, excluding employees from the IT department and contractors from the HR department.d. Retrieves the names of employees from the HR department and contractors from the IT department.

Consider the following tables:Table: EmployeesEmployeeIDNameDepartmentID1Alice102Bob203Charlie304David40Table: DepartmentsDepartmentIDDepartmentName10HR20IT30Finance50Marketing i. Write an SQL query to list all employees with their corresponding department names using an INNER JOIN.ii. Write an SQL query to list all employees and their department names, including those who do not belong to any department (use Left Join)Answer text Question 5EditViewInsertFormatToolsTableHelp

Question 3In the following query, which join returns all records from the employees table, but only records that match on employee_id from the machines table?SELECT *FROM employees _____ machines ON employees.employee_id = machines.employee_id;1 pointRIGHT JOINFULL OUTER JOINLEFT JOININNER JOIN

Consider the table EMPLOYEE(empId, name, department, salary) and the two queries Q1 ,Q2 below. Assuming that department D5 has more than one employee, and we want to find the employees who get higher salary than anyone in department D5, which one of the statements is TRUE for any arbitrary employee table?Q1 :  SELECT  e.empId FROM employee e WHERE NOT EXIST (SELECT * From employee s where s.department = “D5” AND  s.salary >=e.salary)Q2 : SELECT  e.empIdFROM employee eWHERE e.salary > Any (Select distinct salary From employee s Where s.department = “D5”)Q1 is the correct queryQ2 is the correct queryBoth Q1 and Q2 produce the same answer.Neither Q1 nor Q2 is the correct query