Exercise

Test your knowledge

The Venn diagram below describes which method used to check whether the data in one table is present, or absent, in a related table?

The Earthquakes database is available for you to test scenarios in the query console.

Venn Diagram Exclusive Left Outer Join

Instructions

50 XP

Possible Answers

EXISTS
inclusive LEFT OUTER JOIN
INTERSECT
exclusive LEFT OUTER JOIN

Take Hint (-15 XP)