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 |
What are indexes? What are b-trees?
What are some of the important security features of a dbms?
How to Handle Missing Data in a Database?
Why do we study dbms?
Explain top-n analysis in DBMS.
0 Answers ITC Indian Tobacco Company,
Define RDBMS.
0 Answers Ernst Young, Thomson Reuters,
What is called dbms?
What are the steps to follow when preparing to create a table?
What is inner join in database?
What is considered a database?
Explain a checkpoint and when does it occur?
What is the difference between internal and external schema?
Oracle (3259)
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)