Oracle Exam 1Z0-909 Topic 8 Question 39 Discussion

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

Question #: 39
Topic #: 8

[All 1Z0-909 Questions]

Examine these statements issued from Session 1 which execute successfully:

Now, examine this statement issued from Session 2:

What is the outcome of the update statement in Session 2?

AThe row will be updated immediately.

BThe statement will wait for the transaction in Session 1 to finish.

CA deadlock will occur.

DThe transaction in Session 1 will be rolled back automatically.

Show Suggested Answer

Suggested Answer: B, C

by King at Jun 01, 2024, 10:00 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Trina

6 days ago

I think the correct answer is B. The statement will wait for the transaction in Session 1 to finish. The row is locked in Session 1, so Session 2 will have to wait until Session 1 releases the lock.

upvoted 0 times

...

Jacquelyne

21 days ago

But if the statement in Session 2 waits for the transaction in Session 1 to finish, wouldn't that make more sense?

upvoted 0 times

...

Yoko

26 days ago

I disagree, I believe the answer is A) The row will be updated immediately.

upvoted 0 times

...

Jacquelyne

27 days ago

I think the answer is B) The statement will wait for the transaction in Session 1 to finish.

upvoted 0 times

...