Multiple choice technology databases

Which things should be considered while deciding the size of undo tablespace in your database ( choose three)

  1. The size of an undo block

  2. The size of the redo log files.

  3. The size of the database buffer cache.

  4. The value of the UNDO_RETENTION parameter.

  5. Undo blocks generated per second.
Reveal answer Fill a bubble to check yourself
A,D,E Correct answer
Explanation

The UNDO tablespace size depends on three key factors: the physical size of each undo block, the UNDO_RETENTION parameter value (how long undo data must be kept), and the rate of undo block generation per second. The redo log size and buffer cache size influence general database performance but do not directly determine UNDO tablespace sizing.

Keep practicing — related questions