Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

Describe two phases of Two-phase commit?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit - Phase - If all participants respond to the coordinator that they are prepared, the coordinator asks all nodes to commit the transaction, if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What are the various type of snapshots?What is snapshot log?