1Z0-052 · Question #116
Your database is in shutdown state. What will happend if you issue next command: SQL> startup
The correct answer is D. instance started, DB mounted and finally opened. Issuing STARTUP with no arguments takes the database through all three phases in order - instance start (NOMOUNT), mount, and finally open.
Question
Your database is in shutdown state. What will happend if you issue next command:
SQL> startup
Options
- Ainstance will started
- Binstance started and DB is mounted
- Cinstance started, DB opened and finally mounted
- Dinstance started, DB mounted and finally opened
How the community answered
(40 responses)- A3% (1)
- B3% (1)
- C8% (3)
- D88% (35)
Why each option
Issuing STARTUP with no arguments takes the database through all three phases in order - instance start (NOMOUNT), mount, and finally open.
Stopping at the instance-started phase requires the STARTUP NOMOUNT clause; a plain STARTUP continues past NOMOUNT automatically.
Stopping at the MOUNT stage requires the STARTUP MOUNT clause; without it the database continues past mount to the OPEN phase.
The sequence is always NOMOUNT then MOUNT then OPEN - the database must be mounted before it can be opened, so the order described in C is impossible.
The STARTUP command without additional clauses progresses through three sequential phases: first the instance is started by allocating the SGA and launching background processes (NOMOUNT), then the control file is read and the database is mounted, and finally the datafiles and online redo logs are verified and opened, making the database fully accessible to users.
Concept tested: Oracle database startup phases and STARTUP command sequence
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/STARTUP.html
Topics
Community Discussion
No community discussion yet for this question.