nerdexam
Oracle

1Z0-052 · Question #52

You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo…

The correct answer is C. 7, 1, 5, 2, 3, 6 step 4 is not required. After SHUTDOWN IMMEDIATE, Oracle performs a clean checkpoint and rolls back uncommitted transactions, so the correct startup order follows the three phases without requiring instance recovery.

Managing the Database Instance

Question

You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?

Options

  • A7, 1, 5, 2, 3, 6, 4
  • B1, 5, 7, 2, 3, 6; step 4 is not required
  • C7, 1, 5, 2, 3, 6 step 4 is not required
  • D1, 2, 3, 5, 6, 4; step 7 is not required

How the community answered

(36 responses)
  • A
    11% (4)
  • B
    6% (2)
  • C
    78% (28)
  • D
    6% (2)

Why each option

After SHUTDOWN IMMEDIATE, Oracle performs a clean checkpoint and rolls back uncommitted transactions, so the correct startup order follows the three phases without requiring instance recovery.

A7, 1, 5, 2, 3, 6, 4

This option includes step 4 (instance recovery), which is not required after SHUTDOWN IMMEDIATE because a clean shutdown guarantees database consistency with no crash-related redo application needed.

B1, 5, 7, 2, 3, 6; step 4 is not required

This option places SGA allocation (step 1) and background process startup (step 5) before reading the parameter file (step 7), which is impossible because Oracle must read the spfile or pfile first to determine memory sizes and configuration for the SGA and processes.

C7, 1, 5, 2, 3, 6 step 4 is not requiredCorrect

The startup order reflects Oracle's three phases - NOMOUNT (read parameter file: step 7, allocate SGA: step 1, start background processes: step 5), MOUNT (read control file: step 2), and OPEN (read redo log files: step 3, check data files for consistency: step 6). Because SHUTDOWN IMMEDIATE forces a full checkpoint and rolls back all uncommitted transactions before closing, the database is left in a fully consistent state, making instance recovery (step 4) unnecessary on the next open.

D1, 2, 3, 5, 6, 4; step 7 is not required

This option omits the parameter file read (step 7) entirely, but Oracle must always read the spfile or init.ora as the very first action to obtain initialization parameters such as memory targets, control file locations, and instance name.

Concept tested: Oracle database startup phase sequence after clean shutdown

Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/start.htm

Topics

#database startup#SHUTDOWN IMMEDIATE#startup phases#instance recovery

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice