Which of the following is not a transaction management SQL comman

SOLUTION

Concept:

A transaction can be defined as a unit of part of any program at the time of its execution. During this, data items can be read or updated or both. Transaction management is the ability of database management system to manage the different transactions that occur within it.

Explanation:

Concurrency control is the activity of coordinating the actions of transactions that operate simultaneously to access the shared data. Transaction control language commands are used to manage the transaction in the database. These commands are:

COMMIT:

It is used to permanently save any transaction in the database. When changes are done in the transaction , then those changes are not permanent until we perform the COMMIT operation on that.

ROLLBACK:

This command restores the database to the last committed state. If sometimes after changing the data, we realize that changes are not required, then ROLLBACK command is applied at that point.

SAVEPOINT:

This is used to temporarily save a transaction so that rollback can be performed whenever required. Syntax for this is : SAVEPOINT savepoint_name;