Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8362 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 multiple columns?
What is sql and also describe types of sql statements?
How to avoid duplicate records in a query?
What is sql key?
Explain the difference between triggers and constraints?
How can we debug in PL/SQL?
What is schema in sql example?
what is the difference between a web-garden and a web-farm? : Sql dba
what is a view? : Sql dba
what is acid property in database? : Sql dba
Why do we create views in sql?
Can we use ddl commands in pl sql?
Is ms sql is free?
How do I save a sql query?
Does pl sql work in mysql?
