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.
Resolving a lock conflict, the user can either COMMIT or ROLLBACK the current transaction, so B
Scott has to re execute the last command in the transaction after he commits to release the resource and solve the deadlock, so D