Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8365 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya ramesh
grant - it is a statement of DCL (DATA CONTROL LANG)
granting previleges to the user
Commit,Rollback and savepoint are the statements of TCL (TRANSACTION CONTROL LANG)
Commit - Makes a permanent change to the data in the database
Rollback - The changes made in the data can be undone using roll back statement
savepoint - The point upto which the data can be commited while the rest of the datas can be rollbacked as necessary
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is trigger price?
What is a join query?
How can I change database name in sql?
How to load data with sql*loader?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Explain locks? : Transact sql
How to use transactions efficiently : transact sql
What is the difference between distinct and unique in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is pessimistic concurrency control? : Transact sql
What is the difference between explicit and implicit cursors in oracle?
What is orm in sql?
Can you inner join the same table?
What is sql partition function?
how mysql optimizes distinct? : Sql dba
