Which two statements are true in this scenario?

In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? (Choose two.)

In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? (Choose two.)

A.
The alert log file gives detailed information about the failure.

B.
Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

C.
The transaction is rolled back by the next session that refers to any of the blocks updated by the failed transaction.

D.
PMON rolls back the transaction and releases the locks.

E.
SMON rolls back the transaction and releases the locks.

F.
Event Viewer gives more details on the failure.



Leave a Reply 0

Your email address will not be published. Required fields are marked *