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

Question 1Which of this type of join returns an output of only matching records in the two tables? (Select all that apply)1 pointFULL JOINJOININNER JOINLEFT JOIN

You are performing an INNER JOIN on two tables on the employee_id column. The left table is employees, and the right table is machines. Which of the following queries has the correct INNER JOIN syntax?1 pointINNER JOIN machines ON employees.employee_id = machines.employee_idSELECT *FROM employees;SELECT *FROM employeesINNER JOIN machines ON employees.employee_id = machines.employee_id;SELECT *FROM employeesINNER JOIN ON employees.employee_id = machines.employee_id;SELECT *FROM employeesINNER JOIN machines WHERE employees.employee_id = machines.employee_id;

Which JOIN returns all rows when there is a match in one of the tables?  1 pointINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOIN

Question 20When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?1 pointLEFTRIGHTINNEROUTER

Which of these is true of LEFT JOIN? (Select all that apply)1 pointAll records from the left table that have no matching record from the right table.It returns all matching records in both tablesAll records from the right table