The Statement Combines Rows from Two Queries and Excludes Duplicates

question 70

Multiple Choice

The statement combines rows from two queries and excludes duplicates.

• A)UNION
• B)UNION ALL
• C)INTERSECT
• D)MINUS

---

Definitions:

Compound Interest

Interest calculated on the initial principal, which also includes all of the accumulated interest from previous periods on a deposit or loan.

Per Year

A synonym for annually, denoting events or measurements taking place once every calendar year.

Effective Annual Rate

The interest rate on an investment or loan, which is annualized by considering the effect of compounding over a given period.

Amortized Mortgage

A loan for which the principal and interest are paid down through regular payments over the loan's term, leading to full repayment by the end.