Oracle Database 12c: Installation and Administration — Question 96

What is the outcome of the SHUTDOWN ABORT command?

Answer options

• A. Pending transactions are committed and the database is closed.
• B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively.
• C. Uncommitted transactions are rolled back
• D. Instance recovery must be requested by the DBA at the next startup

Correct answer: B

Explanation

The SHUTDOWN ABORT command stops the database immediately without performing clean-up operations, meaning that dirty buffers and unwritten redo are left unwritten. This is why option B is correct, while options A and C are incorrect because they imply that transactions are either committed or rolled back, which does not happen during an abort. Option D is also incorrect as it describes a scenario that is not directly tied to the immediate effects of an abort command.