Home » MCQs » SQL MCQs » SQL Commands: DDL, DML, DCL, TCL, DQL MCQs

What is TRUE about SAVEPOINT?

12. What is TRUE about SAVEPOINT?

1. Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
2. A transaction can be rolled back to its last saved state.
3. A specific part of a transaction can be given a name
4. None of the above

Answer: C) A specific part of a transaction can be given a name

Explanation:

In the case of the SAVEPOINT command, a specific part of a transaction can be given a name.