Which JOIN does the following: returns all the values from the right table, plus matched values from the left table or NULL in case of no matching join predicate.FULL OUTER JOININNER JOINRIGHT JOINLEFT JOIN

What type of JOIN returns all records when there is a match in either table?a.leftb.innerc.rightd.full outer

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

What type of JOIN returns all rows when there is a match in either left or right table?

Which type of join returns all rows in the left table regardless of whether there are matches in the right table?Select one:a.Hash joinb.Full outer joinc.Left outer joind.Right outer join

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