Refer to the exhibit. Which type of SQL JOIN operation would return all the rows from Table 1 and Table 2?
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- INNER JOIN
| Answers Explanation & Hints:
A FULL JOIN returns all rows from Table 1 and Table 2. Values that are not met by the join condition are replaced with a NULL value. |