Multiple choice technology databases

Which condition in your database forces you to perform only consistent backups?

  1. The database is in mount state.

  2. One of the tablespaces is offline.

  3. One of the tablespaces is read only.

  4. The database operates in ARCHIEVELOG mode.

  5. The database operates in NOARCHIEVELOG mode.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

In NOARCHIVELOG mode, Oracle cannot perform hot/inconsistent backups because there are no archived redo logs to recover transactions. Only consistent (cold) backups are possible where the database is cleanly shut down. ARCHIVELOG mode allows both consistent and inconsistent backups.

Keep practicing — related questions