1Z0-052 · Question #93
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, yo
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #93. 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 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.)
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 reexecute the last command in the transaction after he commits the transaction.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.