nerdexam
Oracle

1Z0-062 · Question #324

What is the outcome of the SHUTDOWN ABORT command?

The correct answer is B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log. The SHUTDOWN ABORT command immediately terminates the Oracle database instance without any cleanup, requiring instance recovery upon the next startup.

Managing the Database Instance

Question

What is the outcome of the SHUTDOWN ABORT command?

Options

  • APending transactions are committed and the database is closed.
  • BDirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log
  • CUncommitted transactions are rolled back
  • DInstance recovery must be requested by the DBA at the next startup

How the community answered

(47 responses)
  • A
    6% (3)
  • B
    87% (41)
  • C
    2% (1)
  • D
    4% (2)

Why each option

The SHUTDOWN ABORT command immediately terminates the Oracle database instance without any cleanup, requiring instance recovery upon the next startup.

APending transactions are committed and the database is closed.

This describes a normal or transactional shutdown, where pending transactions are either committed or rolled back, and the database is properly closed.

BDirty buffers in the buffer cache and unwritten redo are not written to the data files and redo logCorrect

The SHUTDOWN ABORT command terminates the instance processes immediately without writing dirty buffers from the buffer cache to data files or unwritten redo information to the redo log files. This abrupt termination leaves the database in an inconsistent state, necessitating instance recovery when the database is subsequently started.

CUncommitted transactions are rolled back

This describes a transactional shutdown, where uncommitted transactions are rolled back before the instance shuts down.

DInstance recovery must be requested by the DBA at the next startup

While instance recovery is required at the next startup after a SHUTDOWN ABORT, it is an automatic process performed by the instance itself, not explicitly requested by the DBA.

Concept tested: Oracle database shutdown modes and their effects

Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/admin/shutting-down-and-starting-up-the-oracle-database.html#GUID-E138E101-CF99-4A73-AA48-735AF385966B

Topics

#SHUTDOWN ABORT#Database Shutdown#Instance Recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice