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:

Forward Rates

Interest rates or financial transaction rates agreed upon now, to be executed at a future date.

Yield Curve

A graphical representation that shows the relationship between interest rates and the maturity dates of debt securities.

Treasury Bond

A long-term, government-issued security with a fixed interest rate and maturity of more than 10 years, considered to be one of the safest investments.

STRIPS

Separate Trading of Registered Interest and Principal of Securities; a form of a bond that separates its interest payments from its principal repayment obligation, enabling investors to hold and trade them separately.