Pergunta de entrevista da empresa Avanade

What considerations should be made with respect to database transactions?