adspace


What are commit, rollback, and savepoint?

Answer Posted / Drishti Bharti

Commit is a SQL command used to permanently save all the changes made in a database transaction. Rollback is a SQL command used to undo all the changes made during a current transaction. Savepoint is a named point within a transaction that allows rolling back only part of the transaction to a specific state.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


Can we use distinct and group by together?

1147


Is primary key clustered index?

1028


define sql insert statement ? : Sql dba

1110


what is schema? : Sql dba

1164


What is the current version of sql?

1106


What is the best sql course?

1064


What is the current version of postgresql?

1188


Do we need to rebuild index after truncate?

1155


how to escape special characters in sql statements? : Sql dba

1124


How do I remove duplicates in two columns?

1202


Does group by remove duplicates?

1121


what are aggregate and scalar functions? : Sql dba

1142


how many tables will create when we create table, what are they? : Sql dba

1156


how to start mysql server? : Sql dba

1279