1Z0-062 · Question #340
Which three database operations can be performed only at MOUNT state? (Choose three.)
The correct answer is A. performing Flashback Database C. enabling or disabling ARCHIVELOG mode E. performing full database recovery. This question asks to identify three database operations that must be performed when an Oracle database is in the MOUNT state. The correct operations are performing Flashback Database, enabling/disabling ARCHIVELOG mode, and performing full database recovery.
Question
Which three database operations can be performed only at MOUNT state? (Choose three.)
Options
- Aperforming Flashback Database
- Brenaming control files
- Cenabling or disabling ARCHIVELOG mode
- Dre-creating control files
- Eperforming full database recovery
How the community answered
(25 responses)- A72% (18)
- B12% (3)
- D16% (4)
Why each option
This question asks to identify three database operations that must be performed when an Oracle database is in the MOUNT state. The correct operations are performing Flashback Database, enabling/disabling ARCHIVELOG mode, and performing full database recovery.
Performing a Flashback Database operation requires the database to be in the MOUNT state so that Oracle can revert the database to an earlier point in time by using flashback logs and archived redo logs.
Renaming control files involves modifying the database's initialization parameters and typically requires the database to be shut down, files moved at the OS level, and then restarted in MOUNT mode; the actual rename is not an 'only at MOUNT state' SQL operation.
Switching a database between ARCHIVELOG and NOARCHIVELOG modes is a critical operation that alters the database's logging behavior and requires the database to be mounted but not open.
Re-creating control files typically involves starting the database in `NOMOUNT` state (not MOUNT) to execute the `CREATE CONTROLFILE` command before the database can be mounted.
Performing a full database recovery, especially point-in-time recovery, often requires the database to be in the MOUNT state to apply archived redo logs and restore data files without user activity.
Concept tested: Oracle database states and operations
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-a-database.html#GUID-E5002C4C-E8B8-435E-921C-D2ED5702681E
Topics
Community Discussion
No community discussion yet for this question.