Help - how is delete handled in MSP_tasks

[yashr]

I have a 'For insert' trigger on MSP_tasks so, whenever an identified task is entered its writes some of the task information to a custom db/table.
However, when I delete one of these identified tasks through MS project , I want to set a 'for delete' trigger so it can update a flag in the custom table.

My questions are :

When I delete a task, does the row get physically deleted or does it get updated to 'NULL' values? I see that it gets marked as 'NULL' temporarily and then gets deleted.

Should I be using 'for update' or 'for delete' for updating
the custom table?

Any help/advice is appreciated.