Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between DELETE and TRUNCATE?

Answer Posted / althaf

the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rownum?

963


What is the difference between microsoft sql and mysql?

950


What is union, minus and interact commands?

1269


Why is there a need for sqlcode and sqlerrm variables?

1029


What is the syntax to add a record to a table?

1071


Explain what is an index?

1034


what is the difference difference between procedure and packages

10364


How subquery works in sql?

1052


What are the commands used in sql?

1047


How is pl sql different from sql?

1059


tell me about various levels of constraint. : Sql dba

1025


What does (*) mean in sql?

937


What is sql clause?

1034


When to use inner join and left join?

937


What are the different dcl commands in sql?

1120