SQL multiple choice questions

1. The EMPLOYEES and DEPARTMENTS tables have two identically named columns: DEPARTMENT_ID and MANAGER ID. Which of these statements joins these tables based only on common DEPARTMENT_ID values? (Choose all that apply): a) SELECT FROM EMPLOYEES NATURAL JOIN DEPARTMENTS b) SELECT* FROM EMPLOYEES E NATURAL JoIN DEPARTMENTS D ON E.DEPARTMENT_ID-DDEPARTMENT_ID; c) SELECT * FROM EMPLOYEES NATURAL JOIN DEPARTMENTS USING (DEPARTMENT_ID); d) None of the above 2. The EMPLOYEES and DEPARTMENTS tables have two identically named columns: DEPARTMENT_ID and MANAGER_ ID. Which statements join these tables based on both column values? (Choose all that apply,): a) SELECT FROM EMPLOYEES NATURAL JOIN DEPARTMENTS; b) SELECT FROM EMPLOYEES JOIN DEPARTMENTS USING (DEPARTMENT_ID,MANAGER_ID); c) SELECT* FROM EMPLOYEES E JOIN DEPARTMENTS D ON E. DEPARTMENT ID-D.DEPARTMENTID AND E.MANAGERID-D. MANAGER ID; - d) None of the above 3. Which join is performed by the following query? SELECT E.JOB_ID ,J.JOB_ ID FROM EMPLOYEES E JOIN JOBS J ON (E.SALARY