nerdexam
Oracle

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.

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

How the community answered

(40 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    8% (3)
  • D
    88% (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.

Ainstance will started

Stopping at the instance-started phase requires the STARTUP NOMOUNT clause; a plain STARTUP continues past NOMOUNT automatically.

Binstance started and DB is mounted

Stopping at the MOUNT stage requires the STARTUP MOUNT clause; without it the database continues past mount to the OPEN phase.

Cinstance started, DB opened and finally mounted

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.

Dinstance started, DB mounted and finally openedCorrect

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

#startup sequence#instance startup#mount#database open

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice