Home » MCQs » SQL MCQs » SQL Concatenate, Savepoint, TIME MCQs

Which of the following is TRUE about Savepoint command?

6. Which of the following is TRUE about Savepoint command?

1. A transaction is marked in a table by this TCL command.
2. Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
3. In order to rollback part of a table rather than the entire table, a savepoint is useful.
4. All of the above

Answer: D) All of the above

Explanation:

Some of the points about Savepoint command are:

1. A transaction is marked in a table by this TCL command.
2. Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
3. In order to rollback part of a table rather than the entire table, a savepoint is useful.