how to handle rollback in sql code example

Example: can we rollback in sql

es, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.