Oracle Database Administration I — Question 17

Which two statements are true about UNDO and REDO? (Choose two.)

Answer options

• A. The generation of UNDO generates REDO
• B. DML modifies Oracle database objects and only generates UNDO
• C. The generation of REDO generates UNDO
• D. DML modifies Oracle database objects and only generates REDO
• E. DML modifies Oracle database objects and generates UNDO and REDO

Correct answer: A, E

Explanation

Option A is correct because the process of generating UNDO data inherently creates corresponding REDO data to ensure data integrity. Option E is also correct as DML operations generate both UNDO for rollback purposes and REDO for recovery. The other options are incorrect because they inaccurately state the relationships between UNDO and REDO generation.