Oracle Exam 1Z0-909 Topic 7 Question 33 Discussion

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

Question #: 33
Topic #: 7

[All 1Z0-909 Questions]

Examine these statements issued from Session 1 which execute successfully:

Now, examine these statements issued from Session 2 which execute successfully:

Session 2>

BEGIN;

UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ;

Which two are true?

ASession 1 takes a shared lock on all the rows in the band table.

BSession 1 must commit before the update in Session 2 can complete.

CSession 1 does not block Session 2.

DStatements in Session 2 are committed.

ESession 2 takes an exclusive lock on all the rows in the band table.

FSession 2 does not start a transaction.

Show Suggested Answer

Suggested Answer: B, D

by Joesph at Mar 21, 2024, 12:54 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Carman

6 months ago

I think only the UPDATE statement in Session 2 is committed.

upvoted 0 times

...

Johnetta

6 months ago

That makes sense. So, which statements in Session 2 are committed?

upvoted 0 times

...

Marion

6 months ago

No, Session 2 does not start a transaction.

upvoted 0 times

...

Carman

6 months ago

So, does Session 1 need to commit before Session 2 can complete?

upvoted 0 times

...

Johnetta

6 months ago

I believe Session 2 takes an exclusive lock on all the rows in the band table.

upvoted 0 times

...

Carman

6 months ago

I think Session 1 does not block Session 2.

upvoted 0 times

...

Thea

7 months ago

Alright, I see your point. A, B, and D might be the correct answers then.

upvoted 0 times

...

Vallie

7 months ago

I agree with Lai, A seems to be a valid point.

upvoted 0 times

...

Lai

7 months ago

But Session 1 does take a shared lock, so I think A is also correct.

upvoted 0 times

...

Thea

7 months ago

I disagree, I believe it's C and E.

upvoted 0 times

...

Lai

7 months ago

I think the correct answers are B and D.

upvoted 0 times

...