Multiple choice technology databases

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)

  1. Restore the data file and perform incomplete recovery.

  2. Restore the data file and perform point-in-time recover.

  3. Drop the tablespace and lose all data in the tablespace.

  4. Restore the database and lose all data since the last backup.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

In NOARCHIVELOG mode, Oracle does not archive redo logs, so you cannot perform media recovery (incomplete or point-in-time) which requires archived logs. The only valid options are: (1) dropping the tablespace and losing only its data, or (2) restoring the entire database from the last backup and losing all changes since that backup. Options A and B are invalid because they require archived redo logs for recovery.

Keep practicing — related questions