The Syntax for a Left Outer Join Is

question 5

Multiple Choice

The syntax for a left outer join is .

• A)SELECT column-list FROM table1 OUTER JOIN table2 LEFT
• WHERE join-condition
• B)SELECT column-list FROM table1 LEFT [OUTER] JOIN table2
• ON join-condition
• C)SELECT column-list WHERE LEFT table1 = table 2
• D)SELECT column-list FROM table1 LEFT table2 [JOIN]
• WHERE join-condition

---

Definitions:

Amortized Loan

A loan with scheduled periodic payments that consist of both principal and interest, designed to pay off the debt over a set period.

Effective Rate

The actual interest rate an investor receives or pays on a financial product, factoring in the effects of compounding.

Amortization Schedule

A table detailing each periodic payment on an amortizing loan, including breakdowns of principal and interest.

Amortizes Loans

Loans for which periodic payments are made that include both interest and principal, gradually reducing the outstanding balance.