Describe two phases of Two-phase commit ?
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 |
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
Is facebook a database?
What is the use of database management system?
Tell me about view, sequence and index in DBMS.
What is pdo in database?
What is equi-join?
Which database is best for large data?
What do you mean by starvation in dbms?
How do I convert a spreadsheet to a database?
What is mean by dbms?
What is stored in a database?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)