Pergunta de entrevista da empresa ITC Infotech

what are the SQL locks resources and model how do you insert and updated at same time without using temp table,table variable,cte