When using an OUTER JOIN, you must explicitly state what kind of OUTER JOIN you want - a LEFT JOIN, a RIGHT JOIN, or a FULL JOIN. (T/F)1 pointTrueFalse

Question 1An INNER JOIN returns only the rows that match. (T/F)1 pointTrueFalse

Which of the following are valid types of JOINs? 1 pointLEFT OUTER JOINRIGHT OUTER JOINFULL OUTER JOINFULL LEFT JOINAll of the above

Which JOIN returns all rows when there is a match in one of the tables?  1 pointINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOIN

Which join types return all rows from only one of the tables being joined? Select all that apply.1 pointFULL OUTER JOINRIGHT JOININNER JOINLEFT JOIN

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