Multiple choice technology databases

Data files of which three tablespaces can be recovered by performing an open recovery?

  1. TEMP

  2. UNDO

  3. INDEX

  4. SYSAUX

  5. SYSTEM
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

TEMP tablespace files can be recovered while the database is open because temporary data is reconstructable. INDEX tablespace is purely structural - indexes can be rebuilt. SYSAUX contains auxiliary data that can be recovered online. SYSTEM tablespace requires the database to be closed for recovery as it's critical for database operation. UNDO tablespace requires special handling and typically needs the database closed.

Keep practicing — related questions