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
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please