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

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 join types return all rows from only one of the tables being joined? Select all that apply.1 pointFULL OUTER JOINRIGHT JOININNER JOINLEFT JOIN

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

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