Multiple choice technology databases

Your database is opened in NOARCHIVELOG mode. You decide to place the database in ARCHIEVELOG mode. How would you do this? ( Choose two)

  1. Execute the ALTER DATABASE ARCHIVELOG statement

  2. Select ARCHIVELOG option in database control and restart the database to apply the changes.

  3. Shutdown and restart the instance, and in NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

  4. Shutdown and restart the instance mount the database and execute the ALTER DATABASE ARCHIVELOG statement.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

To enable ARCHIVELOG mode, the database must be in MOUNT state (not open or NOMOUNT). You can: 1) Use Database Control to select ARCHIVELOG mode and restart (option B), or 2) Manually shutdown, mount with STARTUP MOUNT, execute ALTER DATABASE ARCHIVELOG, then open. Option C is wrong because NOMOUNT doesn't access control files, and option A is incomplete without the mount state requirement.

Keep practicing — related questions