Whenever a change is made to data,the ____ stores a copy of the changed data and the original data,in case it is needed.
A) redo log buffer
B) Java pool
C) shared pool
D) streams pool

Question

Quizplus · Accepted Answer

The redo log buffer in a database system stores a copy of the changed data (in the form of redo records) and the original data, which is necessary for recovering the database in case of a system failure. The redo log buffer is a temporary storage area in the SGA (System Global Area) of a database instance, and its contents are periodically written to the redo log files on disk. The other options, Java pool, shared pool, and streams pool, are different types of memory structures in the SGA that are used for various purposes such as storing Java objects, storing shared SQL and PL/SQL code, and managing data streams between database servers.

Whenever a Change Is Made to Data,the ____ Stores a Copy