______JOIN: Returns rows when there is a match in both tables based on the join conditiona.outerb.nonec.fulld.inner

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

The INNER JOIN clause?Returns all rows that have matching value in the field on which the 2 tables are joined.Returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.Returns all rows from 2 tables.Returns all the matching rows from 2 tables.

According to the ___ condition, Inner Join is derived from matched data.*Greater thanLesser thanEqualityNull

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

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