Multiple choice technology databases

Which of the following commands places the database in ARCHIVELOG mode?

  1. ALTER SYSTEM ARCHIVELOG;

  2. ALTER DATABASE ARCHIVELOG;

  3. ALTER SYSTEM SET ARCHIVELOG=TRUE;

  4. ALTER DATABASE ENABLE ARCHIVELOG MODE;

  5. ALTER DATABASE ARCHIVELOG MODE;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ALTER DATABASE ARCHIVELOG is the correct SQL command to enable ARCHIVELOG mode. This requires the database to be mounted but not open, and is typically followed by a backup.

Keep practicing — related questions