what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 7703 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 auto increment? : Sql dba
What is sql procedures and functions?
What are transaction and its controls?
How to change sql*plus system settings?
What is bitemporal narrowing?
What is a trigger word?
What is structural independence and why is it important?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Is and as keyword in pl sql?
How many types of triggers are there in pl sql?
how to include numeric values in sql statements? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is clustered index sql?
What has stored procedures in sql and how we can use it?
Does a join table need a primary key?
