Question

ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a COMMIT?
a. Five SQL statements are executed
b. The end of a program is successfully reached
c. The program is abnormally terminated
d. The database is shut down for maintenance

Answer 1

Answer:

Option b is the correct answer for the above question.  

Explanation:

ANSI defines some rules for the transaction that happens in SQL to protect the error which generally happens in the transaction. For example, when a person withdraws money from the bank and the bank data is affected but their account data will remains the same then the bank faces the problem of loss.

It defines COMMIT for end of transaction so that if a transaction is affecting one object then after commit the new value of that object is used but if the user does not commit the transaction then the only old value of the object is used which is caused the problem. Option b states that The program's ends have completed successfully and the COMMIT command also means the same. that's why option b is the correct answer while the other is not because--

• Option 'a' states that the five states of SQL are executed, but the commit command does not do so.
• Option b states that the program is terminated abnormally, but the commit command does its reverse.
• Option d states that the database is stopped and processes the maintenance processor, but the commit command also does not do so.