Multiple choice

Which of the following is a false statement about the data flow in Oracle database?

  1. The log buffer is responsible for records all the changes made to the buffer cache.

  2. The log buffer is a part of SGA (System Global Area).

  3. The serve process makes an entry to log buffer to execute the SQL statements.

  4. The log buffer is not responsible to redo the changes in case of a recovery process.

  5. None of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is a false statement as log buffer records all changes made to buffer cache and these changes can be done again  in the recovery process.

Keep practicing — related questions