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 is index hunting and how does it help in improving query performance?

1491


How is data stored in a relational database?

503


Is there an example how to configure externalfileaccess setting in firebird.conf?

470


Explain the use of assign statement in progress database?

524


Is sql a rdbms?

450






Explain the syntax of named procedure?

537


Explain the difference between two and three-tier architectures.

517


Describe concurrency control.

535


What is the importance of query in database?

485


What is database connection pool size?

455


How do you create a report in a database?

448


How to create a database from my program?

522


What is dbms and its advantages?

511


Which is the best free database software?

465


Who has the largest database?

472