nerdexam
Oracle

1Z0-052 · Question #3

For which database operation would you need the database to be in the MOUNT state?

The correct answer is E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes. Switching the database between ARCHIVELOG and NOARCHIVELOG mode requires MOUNT state because Oracle must access the control file while keeping data files offline.

Managing the Database Instance

Question

For which database operation would you need the database to be in the MOUNT state?

Options

  • ARenaming the control files
  • BRe-creating the control files
  • CDropping a user in your database
  • DDropping a tablespace in your database
  • EConfiguring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

How the community answered

(41 responses)
  • A
    5% (2)
  • B
    2% (1)
  • D
    2% (1)
  • E
    90% (37)

Why each option

Switching the database between ARCHIVELOG and NOARCHIVELOG mode requires MOUNT state because Oracle must access the control file while keeping data files offline.

ARenaming the control files

Renaming control files is performed at the OS level while the database is fully shut down, followed by updating the CONTROL_FILES parameter - it does not require MOUNT state to execute.

BRe-creating the control files

Re-creating control files with CREATE CONTROLFILE requires the database to be in NOMOUNT state, not MOUNT, because the control file itself is being constructed from scratch.

CDropping a user in your database

Dropping a user is a data dictionary operation that requires the database to be fully OPEN so that the data dictionary and system tablespace are accessible.

DDropping a tablespace in your database

Dropping a tablespace requires the database to be in OPEN state so Oracle can update the data dictionary and confirm the tablespace is offline and empty.

EConfiguring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modesCorrect

The command ALTER DATABASE ARCHIVELOG or ALTER DATABASE NOARCHIVELOG requires the database to be mounted but not open. In MOUNT state, Oracle has parsed the control file and can persist the archiving mode change there, but the data files are not yet online, which is the prerequisite state for this structural database configuration change.

Concept tested: Database startup states required for archivelog mode changes

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-archived-redo-log-files.html

Topics

#database startup states#MOUNT state#ARCHIVELOG mode#database modes

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice