Aborted database shutdown proceeding conditions - Oracle DBA

Q.  An aborted database shutdown proceeds with which of the following conditions?
- Published on 12 Aug 15

a. New connections are allowed, nor are new transactions not allowed to be started, after the statement is issued.
b. Current client SQL statements not being processed by Oracle Database are immediately terminated.
c. Uncommitted transactions are rolled back
d. Oracle Database does wait for users currently connected to the database to Connect. The database implicitly connects all connected users.
e. None of the above

ANSWER: None of the above


  • Nirja Shah   -Posted on 21 Aug 15
    -Oracle has three types of shutdown mode
    Normal - This mode waits for the work to get completed and takes hours to complete.

    Immediate -This mode terminates all the sessions and does a rollback on all the uncommitted transactions.

    Abort - This mode aborts all the sessions. It leaves the current DML in need of a rollback, de-allocates the SGA and terminates the background processes. It simply means that it will terminate all the active work of Oracle.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)