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 |
What is sql*loader and what is it used for? : aql loader
What is a database link?
How delete a row in sql?
Difference between inline query and stored procedure?
List and explain the different types of join clauses supported in ansi-standard sql?
I need to write a simple query,which one is better select statement or stored procedure?and why?
Can a view be mutating? If yes, then how?
How to run pl sql program in mysql?
how can you see all indexes defined for a table? : Sql dba
Does postgresql run on the cloud?
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?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)