Organizational Research By

Surprising Reserch Topic

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.

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.