CompTIA ITF+ (FC0-U61) — Question 132

Which of the following will a company do to update a customer's address while using a flat file database?

Answer options

• A. Update the address for each order the customer placed.
• B. Update the address in the customer address table.
• C. Update the address field in the customer order table.
• D. Update the primary key to reflect the customer's address.

Correct answer: B

Explanation

The correct answer is B because updating the customer's address directly in the customer address table ensures that all future references to that address are accurate. The other options involve updating multiple records or fields, which can lead to inconsistencies and is not the correct approach for a flat file database.