Oracle
1Z0-052 · Question #116
1Z0-052 Question #116: Real Exam Question with Answer & Explanation
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.
Managing the Database Instance
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
Explanation
Issuing STARTUP with no arguments takes the database through all three phases in order - instance start (NOMOUNT), mount, and finally open.
Common mistakes.
- A. Stopping at the instance-started phase requires the STARTUP NOMOUNT clause; a plain STARTUP continues past NOMOUNT automatically.
- B. Stopping at the MOUNT stage requires the STARTUP MOUNT clause; without it the database continues past mount to the OPEN phase.
- C. 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.
Concept tested. Oracle database startup phases and STARTUP command sequence
Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/STARTUP.html
Topics
#startup sequence#instance startup#mount#database open
Community Discussion
No community discussion yet for this question.