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

Yes... It will be in Log file .. We can ..