[Lock TYPE] DETECT UPDATE CONFLICTS within current TRANS [READ UNCOMMITTED] No [REPEATABLE READ] No,but (DEADLOCK) [SERIALIZABLE] No, but (DEADLOCK) [READ COMMITTED SNAPSHOT] No [SNAPSHOT] YES (Fails transaction) [READ COMMITTED] 
No
N o
Y e s
N O