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

How do I trace sql profiler?

0 Answers  

What are the most important characteristics of pl/sql?

0 Answers  

How can I tell if sql is running?

0 Answers  

how to check myisam tables for errors? : Sql dba

0 Answers  

What is sharding in sql?

0 Answers  




What is sql character function?

0 Answers  

Is sql a programming?

0 Answers  

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

How does a self join work?

0 Answers  

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

What is example of database?

0 Answers  

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

For more SQL PLSQL Interview Questions Click Here
Categories