Java Database Connectivity Question:

Download Job Interview Questions and Answers PDF

What is 2-phase commit?

Java Database Interview Question
Java Database Interview Question

Answer:

A 2-phase commit is an algorithm used to ensure the integrity of a committing transaction. In Phase 1, the transaction coordinator contacts potential participants in the transaction. The participants all agree to make the results of the transaction permanent but do not do so immediately. The participants log information to disk to ensure they can complete In phase 2 f all the participants agree to commit, the coordinator logs that agreement and the outcome is decided. The recording of this agreement in the log ends in Phase 2, the coordinator informs each participant of the decision, and they permanently update their resources.

Download Java Database Interview Questions And Answers PDF

Previous QuestionNext Question
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?When we will Denormalize data?