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.

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 JOIN returns all rows when there is a match in one of the tables?  1 pointINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOIN

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.

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

Which of these is true of LEFT JOIN? (Select all that apply)1 pointAll records from the left table that have no matching record from the right table.It returns all matching records in both tablesAll records from the right table