Oracle Database Administration I — Question 151

Which three are benefits of using temp UNDO when performing DML on global temporary tables? (Choose three.)

Answer options

• A. It reduces the amount of redo generated.
• B. It permits DML on Global temporary tables even if the database is opened read only.
• C. It reduces I/Os to the SYSAUX tablespace.
• D. It reduces I/Os to the SYSTEM tablespace.
• E. It reduces the amount of UNDO stored in the UNDO tablespace.

Correct answer: A, D, E

Explanation

The correct answers are A, D, and E because using temp UNDO indeed minimizes redo generation, reduces I/O for the SYSTEM tablespace, and lowers UNDO storage in the UNDO tablespace. Option B is incorrect since DML cannot be performed on Global temporary tables when the database is in read-only mode.