nerdexam
Oracle

1Z0-082 · Question #86

Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)

The correct answer is D. It is always performed when opening a database. E. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT. See the full explanation below for the reasoning.

Perform Backup and Recovery

Question

Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)

Options

  • AIt is guaranteed to complete within fast_start_mttr_target number of seconds.
  • BNo users can log on until instance recovery has completed.
  • COnly the CURRENT REDO log group is required to perform instance recovery.
  • DIt is always performed when opening a database.
  • EIt always occurs during instance startup performed immediately after a SHUTDOWN ABORT.
  • FThe database opens after the roll forward phase of instance recovery has completed.

How the community answered

(49 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    6% (3)
  • D
    76% (37)
  • F
    14% (7)

Topics

#instance recovery#SHUTDOWN ABORT#roll forward#database startup

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice