Issuing ___________ will cause the named savepoint to be discarded

Options
- TRUNCATE SAVEPOINT
- DELETE SAVEPOINT
- DISCARD SAVEPOINT
- RELEASE SAVEPOINT


CORRECT ANSWER : RELEASE SAVEPOINT

Discussion Board
Explanation.

Answer : RELEASE SAVEPOINT.

The "RELEASE SAVEPOINT" statement removes the named savepoint from the set of savepoints of the current transaction. No commit or rollback occurs. It is an error if the savepoint does not exist.

Jayesh Sonar 03-2-2015 12:40 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement