Define commit, rollback and savepoint?



Define commit, rollback and savepoint?..

Answer / Deependra Kumar

Commit: A SQL command used to save all the changes made in a transaction permanently. Rollback: A SQL command that undoes all the changes made in a transaction. Savepoint: A named point in a transaction where you can roll back to if needed, providing the flexibility to save intermediate results without committing or rolling back.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a memo field?

1 Answers  


What are the basic techniques of indexing?

1 Answers  


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1 Answers   MCN Solutions,


What is write ahead logging in sql server?

1 Answers  


Is coalesce faster than isnull?

1 Answers  


What is Referential Integrity?

3 Answers  


How do you modify a table in sql?

1 Answers  


Can we debug stored procedure?

1 Answers  


How do I use google cloud in sql?

1 Answers  


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1 Answers  


How many sql statements are used? Define them.

1 Answers  


What is a procedure in pl sql?

1 Answers  


Categories