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

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

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

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 rows when there is a match in ONE of the tables?

What does an inner join do?Select one:a.Return all rows in all tablesb.Return only those rows with a matching row in the corresponding tablec.Return all rows in the right table regardless of whether there is a match in the left tabled.Return all rows in the left or right table regardless of whether there is a match in the corresponding table