What type of join is needed when you wish to return rows when there is at least one match in both tables?All of the aboveINNER JOINCROSS-JOINOUTER JOIN

What type of JOIN returns all rows when there is a match in ONE of the tables?

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

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

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 the following join is used to get all the rows from both tables A and B in the resultant table, including those rows that do not have a match in the other table?Answer choicesSelect an optionFull Outer JoinLeft Outer JoinRight Outer JoinNone of the above