Oracle
1Z0-497 · Question #60
1Z0-497 Question #60: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #60. The question stem and answer options stay visible for context.
Question
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?
Options
- 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.
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.