I was asked about how to avoid data corruption in relational databases. (very broadly, not specifics)

Question

Anonymous · Accepted Answer

I basically described transaction management and redundancy. He had to give me a little hint about it. It was a bit difficult because I had not taken databases in a year.

J2EE Developer · Answer

First that comes to mind is data corruption can be greatly minimized if a relational database enforces Referential Integrity for primary/foreign key relationships. RI helps prevent duplicate records or orphaned records (relationship table contains keys for records that do not exist). Second, is transaction processing: set autoCommit to false, run DDL(s), and commit the changes, or rollback the transaction, if any error occurs.

Barclays

Barclays Interview Question

Interview Answers

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches