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 do you mean by super key, primary key, foreign key and candidate key?

749


How many columns are in a database table?

678


Briefly describe an outer join.

720


How to detect applications and users that hold transactions open too long?

692


What is difference between sql and rdbms?

717


Explain the classification of Database Management System?

3972


What are five main functions of a database administrator?

653


Is a database a file?

723


Differentiate table scan from index scan.

699


Why do we need foreign key?

660


What is database Configuration assistant ?

842


What is db context?

667


What is a checkpoint in dbms?

866


What is the first step in creating a database?

664


What are the properties of a primary key in DBMS?

711