1. What is commit, savepoint and Rollback?

Answer:

To delete the data permanently we use 'commit' statement, to roll the transaction back to a certain point, without rolling back the entire transaction we use 'savepoint', to get deleted data rollback is used.

Asked In :: Virtusa Syntel Inc.

keziah :: Sat, February 23, 2019, 5:07:02 am

To delete the data permanently we use 'commit' statement, to roll the transaction back to a certain point, without rolling back the entire transaction we use 'savepoint', to get deleted data rollback is used.