Global Web Forum

husnain

Administrator

From: Chichawatni,Pakistan

Registered: 2014-10-03

Posts: 8,129

Website

Oracle Transaction:

Oracle Quizzes Oracle Transaction

Question:
To ensure that a transaction does not hang if it cannot obtain a lock, which of the following statements below should be executed?

Option A):
UPDATE ... WAIT
Option B):
UPDATE ... NOWAIT
Option C):
FOR UPDATE ... WAIT
Option D):
FOR UPDATE ... NOWAIT

Correct Answer is Option D):
FOR UPDATE ... NOWAIT

---

You cannot discover the new oceans unless you have the courage to lose the sight of the shore.