Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is d diff between grant,commit,rollback n savepoint

Question Posted / korimantu


what is d diff between grant,commit,rollback n savepoint..

Answer / 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

More SQL PLSQL Interview Questions

What is cte sql?

0 Answers  

Why do we use sql constraints?

0 Answers  

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

What is data modelling in sql?

0 Answers  




How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

What is sqlite used for?

0 Answers  

Is record in oracle pl sql?

0 Answers  

What are sql functions? Describe the different types of sql functions?

0 Answers  

What is the difference between a subquery and a join?

0 Answers  

Are stored procedures faster than queries?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories