Multiple choice

Which of the following instance startup stages to a usable state where normal users might access them?

  1. STARTUP NOMOUNT, STARTUP MOUNT, STARTUP OPEN, STARTUP CLOSE

  2. STARTUP OPEN, STARTUP CLOSE, START MOUNTALL

  3. STARTUP EXIT, STARTUP START, STARTUP OPEN, STARTUP CLOSE

  4. STARTUP MOUNT, STARTUP NOMOUNT, STARTUP OPEN
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle instance startup progresses through three main states: NOMOUNT (reads parameter file and starts instance), MOUNT (associates instance with control file and database), and OPEN (makes database available for users). Option D lists all three valid stages. Options A, B, and C include invalid or non-existent commands like STARTUP CLOSE, START MOUNTALL, STARTUP EXIT, and STARTUP START.

Keep practicing — related questions