nerdexam
SAP

C_TADM51702 · Question #66

What happens when an Oracle database shuts down? (Choose two)

The correct answer is A. When using the IMMEDIATE option, open transactions are rolled back before the database is shut down. E. When using the IMMEDIATE option, the database system writes a checkpoint before shutting down the. See the full explanation below for the reasoning.

Question

What happens when an Oracle database shuts down? (Choose two)

Options

  • AWhen using the IMMEDIATE option, open transactions are rolled back before the database is shut down.
  • BWhen using the IMMEDIATE option, an instance recovery is required at the next database startup.
  • CWhen using the NORMAL option, the database system disconnects all users before shutting down the
  • DWhen using the ABORT option, the SAP system is shut down as well.
  • EWhen using the IMMEDIATE option, the database system writes a checkpoint before shutting down the

How the community answered

(55 responses)
  • A
    80% (44)
  • B
    11% (6)
  • C
    4% (2)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Full C_TADM51702 Practice