Oracle Exam 1Z0-908 Topic 2 Question 103 Discussion

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

Question #: 103
Topic #: 2

[All 1Z0-908 Questions]

Examine these entries from the general query log:

All UPDATE statements reference existing rows.

Which describes the outcome of the sequence of statements?

AConnection 24 experiences a lock wait timeout.

BConnection 25 experiences a lock wait timeout.

CA deadlock occurs immediately.

DAll statements execute without error.

EA deadlock occurs after innodb_lock_wait_timeout seconds.

Show Suggested Answer

Suggested Answer: E

by Gregg at Jun 11, 2025, 11:31 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

22 hours ago

Hmm, I think option E is the correct answer. A deadlock seems likely to occur after the lock wait timeout, based on the information provided.

upvoted 0 times

...

7 days ago

I think the outcome will be a deadlock.

upvoted 0 times

...