Database Administrator (DBA) Question:
Download Job Interview Questions and Answers PDF
What is Two-Phase Commit?
Answer:
Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What dynamic data replication? | How can you Enforce Referential Integrity in snapshots? |