Answer / guest

Two-phase commit is mechanism that guarantees a
distributed transaction either commits on all involved nodes
or rolls back on all involved nodes to maintain data
consistency across the global distributed database. It has
two phase, a Prepare Phase and a Commit Phase.

Answer / 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.

Answer / nishi

Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.

Is it possible to open a cursor which is in a Package in another database?

1 Answers   CTS,

---

Are Constraints exported through Export command?

1 Answers  

---

List few disadvantages of file processing system.

0 Answers  

---

Which is the best free database software?

0 Answers  

---

What is normalization in dbms?

0 Answers  

---

Explain data dictionary.

0 Answers  

---

Define database lock?

0 Answers  

---

Where does the LGWR process writes information?

1 Answers  

---

Describe a subquery.

0 Answers  

---

What are procedures in dbms?

0 Answers  

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60

1 Answers   TCS,

---

What is a key field?

0 Answers  

---