RELEASE SAVEPOINT will cause named savepoint to be discarded - Database

Q.  Issuing which type of savepoint will cause the named savepoint to be discarded? (Database)
- Published on 26 Aug 15

a. TRUNCATE SAVEPOINT
b. DELETE SAVEPOINT
c. DISCARD SAVEPOINT
d. RELEASE SAVEPOINT

ANSWER: RELEASE SAVEPOINT
 

    Discussion

  • Nirja Shah   -Posted on 04 Nov 15
    RELEASE SAVEPOINT
    - This statement destroys a savepoint within a transaction and all the savepoints created after the specified savepoint.

    - Whenever a COMMIT or ROLLBACK occurs the savepoint is automatically released.

    - The savepoint name specified in this command should have been created earlier by a savepoint command in the current transaction.

    - If the savepoint name is not found, an exception is raised for the invalid savepoint name.

    - Syntax

    RELEASE SAVEPOINT savepoint_name

    - The savepoint_name can either be an alphanumeric SQL identifier or an integer number.

Post your comment / Share knowledge


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