Question

You notice that somehow you have duplicate records for some of your clients in your database. What should you do?

Answer 1

Inspect them and make sure that they are exact copies then delete one if they are the same.

Answer 2

Answer:

Verify the issue and the delete the duplicate record.

Explanation:

This is a very common situation. Sometimes users access to the database and create an entry two times by accident when two of them are using the same feature of a shared program or when there is a bug which may corrupt the database duplicating information. What you should do is go and check the duplicated record and also review if there is more duplicated data. Try to find the root cause to prevet this from happeing again and, finally, delete the duplicated record.