To ensure that a transaction does not hang if it cannot obtain a lock, – McqOptions

MCQOPTIONS

1.	To ensure that a transaction does not hang if it cannot obtain a lock, which of the following statements below should be executed?
A.	UPDATE ... NOWAIT
B.	FOR UPDATE ... WAIT
C.	FOR UPDATE ... NOWAIT
D.	UPDATE ... WAIT
Answer» D. UPDATE ... WAIT

Discussion

No Comment Found

Related MCQs

Which of the following statements is true after execution of the program?  int a[10],I,*p;  a[0]=1; a[1]=2; p=a; (*p)++;
using' in C++ is for.
Analyse the following code snippet: ClassTemp  {  private:  charm_acEmpName[25];  public:  char*GetFirstChar()  {  strcpy(m_acEmpName,"Hello");  returnthis->m_acEmpName;  }  };  intmain(intargc,char**argv)v {  Temp oTempObject; cout< } .
 Choose the proper statement
NULL is
Which of the following data structures are used in RDBMS.
When a transaction is committed, what does the LGWR do?
To ensure that a transaction does not hang if it cannot obtain a lock, which of the following statements below should be executed?
When does a statement run in a resumable mode?
What do we call transactions in which commit was interrupted by any type of system or network failure?