A ROLLBACK statement will also release any existing savepoints that may be in use.

Options
- True
- False


CORRECT ANSWER : True

Discussion Board
ROLLBACK Statement

The above statement is true. A ROLLBACK statement will also release any existing savepoints that may be in use. In SQL, ROLLBACK is a command that causes all data changes since the last BEGIN WORK, or START TRANSACTION to be discarded by the relational database management systems (RDBMS), so that the state of the data is "rolled back" to the way it was before those changes were made. In most SQL dialects, ROLLBACKs are connection specific. This means that if two connections are made to the same database, a ROLLBACK made in one connection will not affect any other connections. This is vital for proper concurrency.

Prajakta Pandit 03-14-2017 02:55 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