nerdexam
CompTIA

FC0-U61 · Question #489

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

The correct answer is C. Update the address field in the customer order table.. In a flat file database, to update a customer's address, the company must update the address field within the specific customer order table where that information is stored.

Database Fundamentals

Question

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

Options

  • AUpdate the address for each order the customer placed.
  • BUpdate the address in the customer address table.
  • CUpdate the address field in the customer order table.
  • DUpdate the primary key to reflect the customer's address.

How the community answered

(33 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    88% (29)
  • D
    3% (1)

Why each option

In a flat file database, to update a customer's address, the company must update the address field within the specific customer order table where that information is stored.

AUpdate the address for each order the customer placed.

While a flat file might duplicate address information per order, the question asks what a company 'will do,' implying the direct action on the data field, and updating 'each order' is a consequence of the flat-file structure, not the most direct description of the update action itself as compared to C.

BUpdate the address in the customer address table.

Flat file databases typically do not use separate, normalized 'customer address tables'; they embed data, so this choice describes a relational database approach.

CUpdate the address field in the customer order table.Correct

A flat file database typically stores all related information, including customer details like addresses, directly within each record or file, often without normalization. Therefore, to update a customer's address, the change must be applied to the specific address field wherever it appears within the customer order table or associated file that contains that customer's order records. This differs from relational databases where a separate customer address table would exist.

DUpdate the primary key to reflect the customer's address.

The primary key uniquely identifies a record and should not be updated to reflect a customer's address, as addresses are typically attributes, not identifiers.

Concept tested: Flat file database updates

Topics

#flat file database#data updates#database management

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice