Multiple choice

What is the least amount of work needed if the database should be recoverable in the future?

  1. Make a complete backup right after opening the database.

  2. Copy the data file DF1 back to the backup directory.

  3. Back up the data file.

  4. Bring tablespace TS1 online.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Making a complete backup immediately after opening the database ensures that all changes made during recovery (including any uncommitted transactions that were rolled back) are preserved. This provides a recoverable baseline. Options B and C only address individual files, and option D doesn't create any backup.

Keep practicing — related questions