1. Home
  2. Discussions
  3. Oracle
  4. Oracle Database 12c Certified Implementation Specialist
  5. 1z0-497 Discussions
  6. 1z0-497 Exam Topic 2 Question 10 Discussion

Oracle Database 12c Essentials 1z0-497 Question # 10 Topic 2 Discussion

 Oracle Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Oracle Database 12c Essentials 1z0-497 Question # 10 Topic 2 Discussion

1z0-497 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2

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.

Get Premium 1z0-497 Questions
Actual exam question for Oracle 1z0-497 exam by Blaise53921 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next