Q
What is the purpose of SAVEPOINT?
-
A
To save the table to disk permanently
-
B
To mark a point within a transaction to which you can partially roll back
-
C
To create a backup
-
D
To lock a row
Correct Answer:
B. To mark a point within a transaction to which you can partially roll back
Explanation:
Example: ROLLBACK TO SAVEPOINT sp1; undoes work after sp1 only.
