Multiple choice

What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

  1. Application failure

  2. Instance failure

  3. Media failure

  4. Rollback failure

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Instance failure occurs when the Oracle instance (the memory structures and background processes) terminates due to operating system crashes, hardware failures, or power loss. This is distinct from media failure (disk damage), application failure (program errors), or rollback failure (undo segment issues). When the OS or hardware fails, the instance itself fails, making option B correct.