When a transaction is committed, what does the LGWR do? – McqOptions

MCQOPTIONS

1.	When a transaction is committed, what does the LGWR do?
A.	Writes redo log entries in the SGAs redo log buffers to the online redo log file
B.	Writes the transactions SCN to the online redo log file
C.	Both a and b
D.	Writes the unique system change number (SCN) to redo log file.
Answer» D. Writes the unique system change number (SCN) to redo log file.

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?