nerdexam
SAP

C_TADM51_74 · Question #116

What happens when an Oracle database shuts down? There are 2 correct answers to this question.

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

Question

What happens when an Oracle database shuts down? There are 2 correct answers to this question.

Options

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

How the community answered

(44 responses)
  • A
    73% (32)
  • C
    7% (3)
  • D
    5% (2)
  • E
    16% (7)

Community Discussion

No community discussion yet for this question.

Full C_TADM51_74 Practice