Malavika, NO LOCK is a TABLE HINT which instructs Query Optimizer (QO) to do a thing in a different way from the way QO actually planned to do..

You can learn more about TABLE HINTS by clicking this TABLE HINTS

Cheers!!