IT Questions and Answers :)

Wednesday, September 12, 2018

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 

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

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.

Share:

Popular Posts