Free 1Z0-497 Web TestEngine Demo

Q6 Multiple choice

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?

Select all that apply.

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.

1Z0-497 Web TestEngine demo