Architecture and Administration Q018

Which memory structure records all database changes made to the instance?



1. Database buffer.
2. Dictionary Cache
3. Redo Log Buffer
4. Library Cache



Answer 3 - The redo log buffer keeps track of all the changes made to the database before writing them to the redo log files. The database buffer contains the data blocks that are read from data files, and are most recently used. The dictionary cache holds the most recently used data dictionary information. The library cache holds the parsed SQL statements and PL/SQL code.