Describe two phases of Two-phase commit ?

Question Posted / guest

2 Answers
4245 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

Mention the differences between trigger and stored procedures

0 Answers

What are indexes ? What are the advantages ? (Phone Screen)

1 Answers NetApp,

Is it possible to Enable or Disable a Database trigger ?

1 Answers

What is the use of RECORD option in EXP command ?