Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8269 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 faster join or subquery?
What is auto increment?
What is the most common sql injection tool?
What is the maximum database size for sql express?
How do I run a program in pl sql?
how to drop an existing view in mysql? : Sql dba
How can you create an empty table from an existing table?
How many types of keys are there in sql?
How do I view a sql database?
How many triggers can be applied to a table?
What is equi join in sql?
How is use pl and sql?
Why do we need pl sql?
Does pdo prevent sql injection?
Differentiate between % rowtype and type record.
