In SQL, which of the following is the generally preferred way to handle the case where a transaction in progress terminates abnormally?

In SQL, which of the following is the generally preferred way to handle the case where a transaction in progress terminates abnormally?

• Rollforward
• Rollback
• Switch to duplicate database
• Reprocess transactions 

 

EXPLANATION

A transaction is a logical unit of work that contains one or more SQL statements. A transaction is an atomic unit. The effects of all the SQL statements in a transaction can be either all committed (which means that they applied to the database) or all 
rolled back (undone from the database). So, if a transaction terminates abnormally, perform a rollback.