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

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

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