Multiple choice

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

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

  2. It is used to release the lock for the multiple transactions allocated for the same resource.

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

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

  5. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is called 'ISOLATION LEVEL READ COMMITTED ' clause and if a transaction requires row locks held by another transaction, the transaction will wait until the row locks are released.

Keep practicing — related questions