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

What happens to unmatched rows with the full outer join operator?1 pointAll unmatched rows are removed from the result of a full outer join operation. Unmatched rows from both tables are retained in the result of a full outer join operation.Unmatched rows from only one table are retained in the result of a full outer join operation. Unmatched rows are randomly retained in the result of a full outer join operation.

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

In which cases would you use an outer join?Select one:a.The tables being joined have only matched data.b.Only when the tables have a primary key/foreign key relationship.c.The tables being joined have only unmatched data.d.The tables being joined have both matched and unmatched data.e.The tables being joined have NOT NULL columns.

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

Question 1Which of this type of join returns an output of only matching records in the two tables? (Select all that apply)1 pointFULL JOINJOININNER JOINLEFT JOIN