Multiple choice technology databases

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

  1. It is NOT possible to switch unless no active transaction exists in UNDO1.

  2. It is possible to switch to UNDO2, but current active transactions will abort.

  3. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.

  4. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When switching undo tablespaces, Oracle allows active transactions in the old undo tablespace (UNDO1) to complete normally. New transactions use UNDO2, but existing ones continue in UNDO1 until they commit or rollback. This is standard Oracle behavior - you don't need to wait for all transactions to complete before switching.

Keep practicing — related questions