Answer Posted / bindhu
Savepoints are used to create marker in the current
transaction by using SAVEPOINT statement which divides the
transaction into smaller section. We can then dicard
pending changes up to that marker by using the ROLLBACK TO
SAVEPOINT statement.
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
What is sql keyword?
What is view? Can we update view
What is difference between group by and partition by?
What is a design view?
What does where 1/2 mean in sql?
What is the purpose of using pl/sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What happens when a trigger is associated to a view?
what is sql server agent? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
What is the execution plan in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is the difference between rollback and rollback to statements?
What does rownum mean in sql?
