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:

Target Cash Balance

A firm’s desired cash level as determined by the trade-off between carrying costs and shortage costs.

Cost of Borrowing

The total amount of money that a borrower pays to secure a loan, including interest, fees, and any other charges.

Miller-Orr Model

A financial model that helps in managing cash flows and cash reserves of firms, focusing on maintaining an optimal balance level.

Interest Rate

The percentage charged on a loan or paid on deposits over a specific period, reflecting the cost of borrowing or the gain on savings.