Multiple choice

In a client-server configuration, a user is executing a long-running script that performs many inserts. The process hangs, and the user reboots their machine. The user has called for assistance. What steps should the DBA take to assist the user in the execution of the script?

  1. Apply archived redo log files to recover any inserts that were committed prior to the termination of the transaction

  2. Do nothing. The Oracle Server will automatically perform instance recovery

  3. Do nothing. The PMON background process will roll back the transaction releasing any resources and locks

  4. Restore the database to a point-in-time prior to the abnormal termination of the transaction.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When an Oracle client process terminates abnormally, the PMON (Process Monitor) background process automatically detects the failure and rolls back any uncommitted transactions. PMON releases all resources and locks held by the terminated transaction, making them available to other sessions. This is automatic instance recovery at the transaction level. Option A is incorrect because archived redo logs are for media recovery, not transaction rollback. Option B is incorrect because instance recovery doesn't help with incomplete user transactions. Option D is incorrect because point-in-time recovery would lose committed work.

Keep practicing — related questions