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?
Note - Having trouble with the assessment engine? Follow the steps listed here
Answer is not availble for this assesment