Which statement about the LGWR is false?

  1. There is only one redo log writer per instance

  2. A commit confirmation may be issued before a transaction has been recorded in the redo log file

  3. During long transactions Oracle can flush data to the redo logs before it is committed

  4. An Oracle instance cannot survive without a redo log writer


Correct Option: B

Find more quizzes: