Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?
A)OnLine ReDo files
B)Active ReDo files
C)OffLine ReDo files
D)Archive ReDo files
E)All of the above

Question

Quizplus · Accepted Answer

OnLine ReDo files are the only Oracle Database ReDo files that are stored on disk and contain the rollback segments from recent database changes. Active ReDo files are currently being used by the system for database changes and are not stored on disk. OffLine ReDo files are no longer in use by the system and are also not stored on disk. Archive ReDo files are used for backups and recovery and are also not stored on disk.

Which of the Following Oracle Database ReDo Files Are Stored