Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8342 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 programs use sql?
Can 2 queries be executed simultaneously in a distributed database system?
What does trigger mean in psychology?
How to connect a sql*plus session to an oracle server?
What is query syntax?
What are the most important characteristics of pl/sql?
What is dialect in sql?
Where is sql database stored?
Can we create index on primary key?
Can we edit a view in sql?
How do I view a view in sql?
Can we join 3 tables in sql?
What is break?
Can there be more than one function with a similar name in a pl/sql block?
what is the difference between join and union? : Sql dba
