SQL Tutorial

60 / 68

I intend to perform a series of changes in the database and during the transaction, I should be able to always read latest committed data modified (update/delete on existing rows) by other session but I don't want to be able to see any additional rows added and committed by others during the transaction.

Which isolation level should I set for my session?

Get Hint

Note - Having trouble with the assessment engine? Follow the steps listed here

Answer is not availble for this assesment

Loading comments...