Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
boostr.in questions - Question: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?
a. ¬†¬†¬†¬†¬†¬†¬†Apply archived redo log files to recover any inserts that were committed prior to the termination of the transaction
b. ¬†¬†¬†¬†¬†¬†¬†Do nothing. The Oracle Server will automatically perform instance recovery
c. ¬†¬†¬†¬†¬†¬†¬†Do nothing. The PMON background process will roll back the transaction releasing any resources and locks
d. ¬†¬†¬†¬†¬†¬†¬†Restore the database to a point-in-time prior to the abnormal termination of the transaction.
Sep 13, 2013
Sep 12, 2013
to add a comment.
Related Hot Questions
Government Jobs Opening