What are commit, rollback, and savepoint?



What are commit, rollback, and savepoint?..

Answer / 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

More SQL PLSQL Interview Questions

What is sql*loader and what is it used for? : aql loader

1 Answers  


What is a database link?

3 Answers  


How delete a row in sql?

1 Answers  


Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,


List and explain the different types of join clauses supported in ansi-standard sql?

1 Answers  


I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,


Can a view be mutating? If yes, then how?

1 Answers  


How to run pl sql program in mysql?

1 Answers  


how can you see all indexes defined for a table? : Sql dba

1 Answers  


Does postgresql run on the cloud?

1 Answers  


Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,


How do I remove sql developer from windows 10?

1 Answers  


Categories