nerdexam
Oracle

1Z0-052 · Question #239

Your database is in the MOUNT state and you execute the following command to open it: ALTER DATABASE OPEN; What two actions are performed as a result of this command? (Choose two.)

The correct answer is B. All redo log files are opened E. All online data files are opened. The ALTER DATABASE OPEN command transitions the database from MOUNT to OPEN by opening the online data files and online redo log files. Control files and the parameter file are already open from earlier startup phases.

Exploring the Oracle Database Architecture

Question

Your database is in the MOUNT state and you execute the following command to open it:

ALTER DATABASE OPEN; What two actions are performed as a result of this command? (Choose two.)

Options

  • AAll control files are opened.
  • BAll redo log files are opened
  • CThe password file is opened.
  • DThe parameter file is opened.
  • EAll online data files are opened.

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    89% (32)
  • C
    6% (2)
  • D
    3% (1)

Why each option

The ALTER DATABASE OPEN command transitions the database from MOUNT to OPEN by opening the online data files and online redo log files. Control files and the parameter file are already open from earlier startup phases.

AAll control files are opened.

Control files are already opened during the MOUNT phase (ALTER DATABASE MOUNT), not during the subsequent OPEN phase.

BAll redo log files are openedCorrect

Online redo log files are opened during the OPEN phase so Oracle can verify their consistency, perform instance recovery if needed, and begin recording new change vectors for ongoing transactions.

CThe password file is opened.

The password file (orapwd) is read during the NOMOUNT (instance startup) phase to identify SYSDBA/SYSOPER users, not during the OPEN phase.

DThe parameter file is opened.

The parameter file (SPFILE or PFILE) is read during NOMOUNT to initialize instance parameters, well before the database reaches MOUNT or OPEN state.

EAll online data files are opened.Correct

All online data files are opened during ALTER DATABASE OPEN, which includes verifying their headers against the control file SCN and making the actual user data accessible for read and write operations.

Concept tested: Oracle database startup phases and file open sequence

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/starting-up-and-shutting-down.html

Topics

#ALTER DATABASE OPEN#database startup#redo log files#online data files

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice