Multiple choice technology databases

Which statement regarding an incomplete recovery is true?(Oracle 10g)

  1. You do not need to restore all the data files.

  2. You do not need to open the database with the RESETLOGS operation

  3. You do not need to perform a full backup after the RESETLOGS operation.

  4. You do not need to recover all the data files to the same system change number (SCN).
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle 10g, after incomplete recovery with RESETLOGS, the database is in a consistent state and doesn't require an immediate full backup (though it's recommended practice). Options A and D are incorrect - incomplete recovery still requires restoring all datafiles and recovering them to a consistent point. Option B is false - RESETLOGS is mandatory after incomplete recovery to reset the redo log sequence.

Keep practicing — related questions