Database Administrator (DBA) Question:

What is Two-Phase Commit?

Tweet Share WhatsApp

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) PDF Read All 253 Database Administrator (DBA) Questions
Previous QuestionNext Question
What dynamic data replication?How can you Enforce Referential Integrity in snapshots?