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

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.

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

What does the SQL INNER JOIN do?OptionsRetrieves all rows from both tables, regardless of matchingRetrieves some rows from one table and matching rows from anotherRetrieves only the matching rows between two tablesRetrieves all rows from one table and matching rows from another

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.

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