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 is the best database management system?
How do you invoke datastage using unix?
Explain what is an Exception ?
How to pump the data from one database to another?
What is data model example?
What are dml and ddl statements?
What is the difference between SQL and NoSQL databases
What is the purpose of using a model?
Operators used in select statements are?
Mention a query to calculate the even and odd records from a table
i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........
Differentiate table scan from index scan.
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)