1Z0-052 Question #239: Real Exam Question with Answer & Explanation

The correct answer is B: All redo log 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.

Explanation

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.

Common mistakes.

A. Control files are already opened during the MOUNT phase (ALTER DATABASE MOUNT), not during the subsequent OPEN phase.
C. The password file (orapwd) is read during the NOMOUNT (instance startup) phase to identify SYSDBA/SYSOPER users, not during the OPEN phase.
D. The parameter file (SPFILE or PFILE) is read during NOMOUNT to initialize instance parameters, well before the database reaches MOUNT or OPEN state.

Concept tested. Oracle database startup phases and file open sequence

Reference. 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