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

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.

Which of the following is not true about SQL joins?Group of answer choicesA full outer join returns results of an inner join as well as the results of a left and right join.A left or right outer join returns the results of the inner join as well as the unmatched rows in the left or right table respectively.None of the choicesAn inner join is a join of two tables returning only matching rows.

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

Table A and Table B are to be joined in a query.Which type of join will include all rows from tables A and B in the result?

Which JOIN returns only the matching rows from both tables?  1 pointINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOIN