Issuing ___________ will cause the named savepoint to be discarded

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


CORRECT ANSWER : RELEASE SAVEPOINT

Discussion Board
RELEASE SAVEPOINT

Issuing RELEASE SAVEPOINT will cause the named savepoint to be discarded. RELEASE SAVEPOINT 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
where,
The savepoint_name can either be an alphanumeric SQL identifier or an integer number.

Prajakta Pandit 03-9-2017 06:38 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