Intermediate
SQL
Q78 / 100
What is the effect of using a transaction with "SAVEPOINT"?
Correct! Well done.
Incorrect.
The correct answer is B) It creates a named point within a transaction to which you can later roll back, without undoing the entire transaction
B
Correct Answer
It creates a named point within a transaction to which you can later roll back, without undoing the entire transaction
Explanation
SAVEPOINT marks an intermediate point in a transaction; ROLLBACK TO SAVEPOINT undoes only the changes made after that point, while keeping earlier changes within the transaction intact.
Progress
78/100