Oracle
1Z0-032 · Question #74
You need to change your test database from NOARCHIVELOG mode to ARCHIVELOG mode. In the process you execute the ALTER DATABASE command to change the database to ARCHIVELOG mode. What will be the…
The correct answer is B. It sets the database in ARCHIVELOG mode and updates the control file. See the full explanation below for the reasoning.
Question
You need to change your test database from NOARCHIVELOG mode to ARCHIVELOG mode. In the process you execute the ALTER DATABASE command to change the database to ARCHIVELOG mode. What will be the outcome of this command?
Options
- AIt opens the database and sets the database in ARCHIVELOG mode.
- BIt sets the database in ARCHIVELOG mode and updates the control file.
- CIt updates the header of all the data files and sets the database in ARCHIVELOG mode.
- DIt enables the Archiver (ARCn) processes and sets the database in ARCHIVELOG mode.
How the community answered
(41 responses)- A17% (7)
- B73% (30)
- C2% (1)
- D7% (3)
Community Discussion
No community discussion yet for this question.