nerdexam
Oracle

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.

Performing Backup and 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)
  • A
    72% (18)
  • B
    12% (3)
  • D
    16% (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.

Aperforming Flashback DatabaseCorrect

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.

Brenaming control files

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.

Cenabling or disabling ARCHIVELOG modeCorrect

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.

Dre-creating control files

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.

Eperforming full database recoveryCorrect

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

#Database States#MOUNT State#Flashback Database#ARCHIVELOG mode#Database Recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice