Oracle Exam 1Z0-909 Topic 9 Question 35 Discussion

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

Question #: 35
Topic #: 9

[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 Isadora at Apr 22, 2024, 08:34 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Melodie

6 months ago

Yeah, F doesn't seem plausible. So maybe B and C are the answers?

upvoted 0 times

...

Fletcher

7 months ago

Good point, What about F? Session 2 must start a transaction, right?

upvoted 0 times

...

Bonita

7 months ago

True. E seems wrong. I'm leaning towards C. Session 1 does not block Session 2?

upvoted 0 times

...

Melodie

7 months ago

Not sure about A. I doubt E, though. Exclusive lock on all rows?

upvoted 0 times

...

Fletcher

7 months ago

Yeah, definitely involves locking. My guess is A and B.

upvoted 0 times

...

Bonita

7 months ago

This question is tricky. I think it's about database locks and transactions.

upvoted 0 times

...

Talia

8 months ago

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

upvoted 0 times

...

Nguyet

8 months ago

Statements in Session 2 are committed.

upvoted 0 times

...

Tawna

8 months ago

What about statements in Session 2?

upvoted 0 times

...

Talia

8 months ago

No, Session 1 does not block Session 2.

upvoted 0 times

...

Nguyet

8 months ago

Is Session 1 blocking Session 2?

upvoted 0 times

...

Tawna

8 months ago

A and C are true.

upvoted 0 times

...