What action should be taken when a record is determined to be invalid?

• A. Update the record
• B. Cancel the record
• C. Archive the record
• D. Leave the record as is

Answer: (B)

When a record is determined to be invalid, the action to cancel the record is essential for maintaining the integrity and accuracy of the database. Canceling a record ensures that it is completely removed from the system and is no longer accessible or retrievable within the database. This is crucial because invalid records can lead to confusion, misinformation, and potential legal issues when they are incorrectly relied upon for decision-making or law enforcement actions.

Updating the record may seem like a viable option; however, if the record is fundamentally flawed or not accurate, simply modifying it would not resolve the underlying issue. Archiving the record could preserve the invalid data for future reference, but this practice is not suitable in this case as it would still keep the incorrect information within reach instead of safeguarding against misuse. Leaving the record as is would also compromise the data quality and could lead to serious ramifications in situations where accurate records are necessary. Thus, canceling the record is the most appropriate and effective course of action when addressing invalid records.