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 of the following keyword is equivalent to INNER JOIN?Select one:a.JOINb.LEFT JOINc.None of the answers are correctd.RIGHT JOINe.FULL JOIN

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 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

5. What’s the difference between LEFT JOIN and INNER JOIN?  A. LEFT JOIN returns all records from the right table, and the matched records from the left table; INNER JOIN returns only the matched records from both tables.B. LEFT JOIN returns all records from the left table, and the matched records from the right table; INNER JOIN returns only the matched records from both tables.C. LEFT JOIN returns only the matched records from both tables; INNER JOIN returns all records from the left table and the matched records from the right table.D. LEFT JOIN is used to combine rows from two or more tables; INNER JOIN is used to combine columns from two or more tables.

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