Multiple choice

What is 'ISOLATION LEVEL SERIALIZE' parameter in SET TRANSACTION statement in PL/SQL?

  1. It is used to check the resource to be updated by multiple transactions.

  2. If a transaction requires row locks held by another transaction, the transaction will wait until the row locks are released.

  3. It assigns the transaction to a rollback segment identified by 'segment_name'.

  4. It assigns a name to the transaction identified by 'transaction_name'.

  5. Both (1) and (3)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

If a transaction attempts to update a resource that has been updated by another transaction and uncommitted, the transaction will fail.

Keep practicing — related questions