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 a client abnormally terminates, PMON (Process Monitor) automatically detects the failed session, rolls back the uncommitted transaction, releases locks, and frees resources. No manual intervention by the DBA is needed - PMON handles this cleanup automatically.

Keep practicing — related questions