Oracle Exam 1Z0-909 Topic 3 Question 40 Discussion

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

Question #: 40
Topic #: 3

[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 Malcolm at Jun 21, 2024, 01:07 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Laquita

5 months ago

I think Statements in Session 2 are committed, as it starts with BEGIN; and ends with a semicolon.

upvoted 0 times

...

This question is like a riddle wrapped in a mystery inside an enigma. I'm gonna go with A and F - Session 1 takes a shared lock, and Session 2 doesn't start a transaction. Why? Because why not, that's why! *laughs maniacally*

upvoted 0 times

Meaghan

4 months ago

F) Session 2 does not start a transaction.

upvoted 0 times

...

Vincent

4 months ago

A) Session 1 takes a shared lock on all the rows in the band table.

upvoted 0 times

...

Dick

5 months ago

I believe Session 1 does not block Session 2, so both can run concurrently.

upvoted 0 times

...

Tish

5 months ago

Alright, let's do this! I'm thinking B and E - Session 1 has to commit before the update in Session 2 can complete, and Session 2 takes an exclusive lock on the rows. Sounds about right, but who knows, maybe the other candidates have a better idea.

upvoted 0 times

...

Amber

6 months ago

I agree with you, Destiny. That's why Session 1 must commit before the update in Session 2 can complete.

upvoted 0 times

...

Destiny

6 months ago

I think Session 1 takes a shared lock on all the rows in the band table.

upvoted 0 times

...

Edna

6 months ago

Hmm, this looks like a tricky one. I'm gonna go with C and D - Session 1 doesn't block Session 2, and the statements in Session 2 are committed. Easy peasy, right? Well, let's see what the others have to say.

upvoted 0 times

Theron

5 months ago

I agree, Session 1 doesn't block Session 2 and the statements in Session 2 are committed.

upvoted 0 times

...

Ernie

5 months ago

I think you're right, Session 1 doesn't block Session 2 and the statements in Session 2 are committed.

upvoted 0 times

...

Oracle Exam 1Z0-909 Topic 3 Question 40 Discussion

Contribute your Thoughts:

Laquita

Wynell

Meaghan

Vincent

Dick

Tish

Amber

Destiny

Edna

Theron

Ernie