Which two statements are true about SCOTT’s session in …

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
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two
statements are true about SCOTT’s session in this scenario?

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
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two
statements are true about SCOTT’s session in this scenario?

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 to re-execute the last command in the transaction after he commits the transaction.

Explanation:
https://www.youtube.com/watch?v=JitJRb5x9vI



Leave a Reply 1

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