Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / syed sohel
The 2PC protocol is so named because it employs the
following two phases prior to committing the operation
performed:
* Phase 1—Prepare. In this phase, each of the programs
involved in the transaction sends a message to the TP
Manager, such as Microsoft Distributed Transaction
Coordinator (MS DTC), informing the TP Manager that it is
ready to and capable of performing its part of the
operation. This phase is also known as prepare because the
programs are prepared either to commit the changes or
rollback the changes. If the TP Manager receives
confirmation from each of the programs involved, it proceeds
to phase 2.
* Phase 2—Commit or Rollback. In this phase, the TP
Manager instructs each of the programs to commit or rollback
all of the changes that were requested as part of the
transaction. A properly executed rollback should return the
system to its original state.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain top-n analysis in DBMS.
What are partitions in database?
what is storage manager?
Explain the terms database and dbms?
How to load a file into database column?
Explain what are the two types of oltp?
What is the instance of a relation?
Why indexing is used in database?
What are indexes? Mention the differences between the clustered and non-clustered index?
What is natural key?
What is join? Mention its types.
What is the license for clipper?
What is file manager?
What are views in dbms?
What are the three levels of data abstraction?
