Examine these statements issued from Session 1 which execute successfully:Now, examine these statements issued from...

Oracle 1z0-909 Question Answer

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?

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

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

Session 1 does not block Session 2.

Statements in Session 2 are committed.

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

Session 2 does not start a transaction.

Oracle 1z0-909 Summary

Price: $52.5 ~~$149.99~~