Yes... It will be in Log file .. We can ..
yes it is possible data in sql server..
It's not possible if u have not started with BEGIN TRAN. If you Start ur query with BEGIN TRAN Then We can roll back the data