The session of user SCOTT receives the following error after executing an UPDATE
command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting
for resource On investigation, you find that a session opened by user JIM has a transaction
that caused the deadlock. Which two statements are true regarding the session of SCOTT
in this scenario? (Choose two.)
A.
The session is terminated after receiving the error and JIM can continue with his
transaction.
B.
SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his
transaction.
C.
The session is rolled back after receiving the error and JIM can continue with his
transaction.
D.
SCOTT has toreexecute the last command in the transaction after he commits the
transaction.
Hello,
Could someone explain why B and D ?
Thank you
Vin
B – because he is keeping some resource that Jim is needing to complete Jim transaction. Commit to release lock and keeping the partial of Scott transaction (first part) be saving.
D – Scott has completed his first part of transaction – but he has to complete the rest part in order to the transaction to be fully completed.