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 |
What is a memo field?
What are the basic techniques of indexing?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is write ahead logging in sql server?
Is coalesce faster than isnull?
What is Referential Integrity?
How do you modify a table in sql?
Can we debug stored procedure?
How do I use google cloud in sql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How many sql statements are used? Define them.
What is a procedure in pl sql?
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)