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

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 does the SQL JOIN clause do?OptionsSorts rows in a tableDeletes rows from a tableCombines rows from two or more tablesInserts rows into a table

Question 10Which of the following is true about FULL OUTER JOIN created on two tables Table 1 and Table 2?1 pointRetrieves only matched rows of Table 1 and Table 2Retrieves the unmatched rows of Table 2Retrieves both matched and unmatched rows of Table 1 and Table 2Retrieves all the unmatched rows of Table 1

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