Multiple choice technology databases

Your TCS .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database?

  1. Until last commit

  2. Until the time you perform recovery

  3. Until the time the date file got corrupted

  4. Until the point where the last transaction begun

  5. You cannot recover the SYSTEM tablespaceand must re-create the database.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

If the database is in ARCHIVELOG mode and a SYSTEM tablespace data file is corrupted, you can restore and recover the database up to the point of the last committed transaction (until last commit) using archived and online redo logs.

Keep practicing — related questions