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

Karol

1 months ago

This question is like a game of musical chairs - only one session can sit on the row at a time!

upvoted 0 times

...

Dannie

1 months ago

Easy peasy, the answer is B. I can almost hear the crickets chirping in Session 2 while it waits patiently for Session 1 to finish its business.

upvoted 0 times

Lamonica

8 days ago

C) A deadlock will occur.

upvoted 0 times

...

Rosalyn

9 days ago

B) The statement will wait for the transaction in Session 1 to finish.

upvoted 0 times

...

Lajuana

12 days ago

A) The row will be updated immediately.

upvoted 0 times

...

Adrianna

1 months ago

I'll go with B. Waiting for the transaction in Session 1 to finish seems like the most logical outcome here. It's like waiting in line at the DMV - you just have to be patient!

upvoted 0 times

...

Katina

2 months ago

Hmm, I'm not sure about this one. Maybe C? A deadlock could occur if Session 1 and Session 2 are both waiting for each other's locks.

upvoted 0 times

Kerry

7 days ago

C) A deadlock will occur.

upvoted 0 times

...

Ellsworth

8 days ago

B) The statement will wait for the transaction in Session 1 to finish.

upvoted 0 times

...

Johnetta

16 days ago

C) A deadlock will occur.

upvoted 0 times

...

Jesusita

27 days ago

B) The statement will wait for the transaction in Session 1 to finish.

upvoted 0 times

...

Latosha

1 months ago

A) The row will be updated immediately.

upvoted 0 times

...

Veronika

1 months ago

A) The row will be updated immediately.

upvoted 0 times

...

Trina

2 months 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