Multiple choice technology programming languages

Discarding redo logs is done with which of the following statements?

  1. alter database archivelog;

  2. alter database open resetlogs;

  3. alter database mount exclusive

  4. alter system archive log all
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The ALTER DATABASE OPEN RESETLOGS statement initializes and resets the online redo logs, effectively discarding their current content during recovery. Other options change the database's archiving mode, mount it, or archive logs manually, but they do not clear or reset the logs.

Keep practicing — related questions