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, database recovery to a specific point in time or incomplete recovery is impossible because redo logs are not archived. Thus, if a data file is lost, the database must be restored from a cold backup (losing all changes since), or the affected tablespace must be dropped, losing all its data.

Keep practicing — related questions