ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Databases >> SQL-PLSQL
 
 
 
Question
What is the difference between DELETE and TRUNCATE?
 Question Submitted By :: Srikanth
I also faced this Question!!     Rank Answer Posted By  
 
Answer
Whenever we delete records then they are stored in data 
dictionary and can be retrieved later ie by roll back.
but when we truncate then the memory used by the records 
which is to be truncated is released and it cannot be 
rolled back.
 
0
Protyusha Banerjee Dawn
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com