• I selected the options 1 & 4 and lost it.

    I thought the below one is wrong.

    "With an exclusive lock, no other transactions can modify data (except for operations with NOLOCK hint or read uncommitted isolation level)"

    Though I am microsoft certified, I give a lot wrong answers now a days...haaaaa....I need to concentrate more and more.....