Multiple choice

The following command was executed in MOUNT mode:

ALTER DATABASE ARCHIVELOG;

Where is the information that the database is now in ARCHIVELOG mode stored?

  1. SPFILE

  2. Archive Log

  3. Control File

  4. System Tablespace
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a database is switched to ARCHIVELOG mode using ALTER DATABASE ARCHIVELOG, this mode change is recorded in the control file. The control file stores critical database information including the database name, checkpoint information, and archiving mode. SPFILE (option A) stores initialization parameters. Archive logs (option B) are the output of archiving, not where the mode is stored. The System tablespace (option D) stores data dictionary objects, not database state information.

Keep practicing — related questions