Which of the Following Is a Disadvantage of Using an Index

question 39

Multiple Choice

Which of the following is a disadvantage of using an index?

• A) You can only add an index when the table is created.
• B) You can't use indexes with foreign keys.
• C) Record retrieval is less efficient.
• D) The index must be updated whenever the data in the database changes.

---

Definitions:

Sales Discounts

Reductions granted from the listed price of goods or services, often used as a marketing strategy to encourage early payment or increase sales volume.

2/10, N/30

A payment term indicating that a buyer can take a 2% discount on the invoice amount if payment is made within 10 days; otherwise, the net amount is due in 30 days.

Sales Return

goods returned by the customers to the seller after the sale, reducing the gross sales figure.

Gross Profit

The profit a company makes after deducting the costs associated with making and selling its products, or the costs associated with providing its services.