A Type of Join Implemented in SQL-1999 and by Extension

question 60

Multiple Choice

A type of join implemented in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is joined is called a(n) :

• A) outer join.
• B) inner join.
• C) union join.
• D) intersect join.

---

Definitions:

Negotiated

Discussed and agreed upon by parties involved, typically resulting in a formal agreement or contract that accommodates the interests or conditions of those parties.

Instrument

A legal document formalizing an agreement or right, often related to finance or law.

Graduation Gift

An item or sum of money given to someone to celebrate the completion of their graduation.

Talon

In finance, a talon is a coupon on a bearer bond that allows the holder to collect future unattached coupons when they become due.