1.

Is A Shared Lock Assigned To Each Data Record Of The Table During A Full Table Scan As Long As The Query Is Running?

Answer»

In ISOLATION level 1, a lock is temporarily used for each record and is REMOVED before the NEXT record.
In isolation level 3, a table shared lock is used.

In isolation level 1, a lock is temporarily used for each record and is removed before the next record.
In isolation level 3, a table shared lock is used.


Discussion

No Comment Found

Related InterviewSolutions