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.
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)- A3% (1)
- B89% (32)
- C6% (2)
- D3% (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.
Control files are already opened during the MOUNT phase (ALTER DATABASE MOUNT), not during the subsequent OPEN phase.
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.
The password file (orapwd) is read during the NOMOUNT (instance startup) phase to identify SYSDBA/SYSOPER users, not during the OPEN phase.
The parameter file (SPFILE or PFILE) is read during NOMOUNT to initialize instance parameters, well before the database reaches MOUNT or OPEN state.
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
Community Discussion
No community discussion yet for this question.