Oracle Exam 1Z0-497 Topic 3 Question 49 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 49
Topic #: 3

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?

AThe session is terminated after receiving the error and JIM can continue with his transaction.

BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

CThe session is rolled back after receiving the error and JIM can continue with his transaction.

DSCOTT has to re-execute the last command in the transaction after he commits the transaction.

Show Suggested Answer

Suggested Answer: B, D

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

by Nichelle at May 05, 2022, 04:07 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!