Describe two phases of Two-phase commit ?

Question Posted / guest

2 Answers
4435 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Describe two phases of Two-phase commit ?..

Answer / guest

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.

Is This Answer Correct ?

0 Yes

0 No

Describe two phases of Two-phase commit ?..

Answer / nishi

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.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Database Management Interview Questions

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

0 Answers

What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?

1 Answers

Is facebook a database?

0 Answers

What is the use of database management system?

0 Answers

Tell me about view, sequence and index in DBMS.

0 Answers Honeywell, Zomato,

What is pdo in database?

0 Answers

What is equi-join?