Describe two phases of Two-phase commit ?
- 2 Answers
- 3496 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Is there an example how to configure externalfileaccess setting in firebird.conf?
What is maintaining database?
Mention few case manipulation functions in sql
Enlist some commands of ddl?
How to disconnect the user connection?
What do you understand by unique key?
How to change database dialect?
What is advantage of dbms?
What are the two major subsystems of system r?
Explain different types of Views ?
5 Answers HCL, Inbound Solutions,
Explain the Logical Schema of Database
Explain ERASE packaged procedure ?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
