What is Two-Phase Commit ?

Answer Posted / guest

Two-phase commit is mechanism that guarantees a
distributed transaction either commits on all involved nodes
or rolls back on all involved nodes to maintain data
consistency across the global distributed database. It has
two phase, a Prepare Phase and a Commit Phase.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1716


What is the use of database management system?

720


Define dbms.

741


Which two statements are true about a foreign key?

741


How do I keep my database up to date?

721


Why is data modelling important?

665


What is database schema in dbms?

873


What do you understand by e-r model?

769


What are the different types of database?

729


Is file system a database?

717


What are the different type of relationships in the dbms?

682


How to reorder the table columns (fields)?

842


What is data sparsity and how it effect on aggregation?

750


What is called dbms?

698


What happens when my integer identity runs out of scope?

671