Describe two phases of Two-phase commit ?

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

State three differences between Dbms and Rdbms?

0 Answers   BirlaSoft,


What is the best database software?

0 Answers  


What is db dialect?

0 Answers  


How to pump the data from one database to another?

0 Answers  


I want to export the data date to date from oracle database then what can i do?

0 Answers  






Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

0 Answers  


what are the differences between network and hierarchical database model?

0 Answers  


What database should I learn first?

0 Answers  


What is the structure of a table in database?

0 Answers  


Do I need ccp4?

0 Answers  


What is the sql 'in' clause?

0 Answers  


Explain fully functional dependency?

0 Answers  


Categories