A Select Query That Finds Duplicate Records in a Table

question 47

Multiple Choice

A select query that finds duplicate records in a table or query.

• A) find unmatched query
• B)SQL (Structured Query Language)
• C)list-of-values match
• D)table validation rule
• E)Long Text
• F)lookup field
• G)pattern match
• H)Validation Rule
• I)find duplicates query
• J)property propagation

---

Definitions:

Discount Rate

The interest rate used in discounted cash flow analysis to determine the present value of future cash flows, reflecting the risk and time value of money.

Yearly Payments

Payments made once per year, often related to loans, annuities, or insurance policies.

Effective Annual Rate

The interest rate on an investment or loan over a year, taking into account the effect of compounding.