what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8515 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
how to use regular expression in pattern match conditions? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Can we rollback truncate?
Is primary key always clustered index?
how many tables will create when we create table, what are they? : Sql dba
what is dbms? : Sql dba
Can we use distinct and group by together?
What is the current version of postgresql?
Does group by remove duplicates?
Do we need to rebuild index after truncate?
Is primary key clustered index?
what is bcp? When does it used? : Sql dba
define sql insert statement ? : Sql dba
Is inner join faster than left join?
How do I remove duplicates in two columns?
