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 are synonyms in sql?

0 Answers  

Can we use out parameter in function?

4 Answers   Infosys,

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

Explain the order of sql statement execution?

0 Answers  

What are the set operators in sql?

0 Answers  




I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

Does execute immediate commit?

0 Answers  

what is unique key constraint? : Sql dba

0 Answers  

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

What is an ndf file?

0 Answers  

Explain ddl statements in pl/sql?

0 Answers  

What are the constraints available in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories