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 difference between TRUNCATE & DELETE?

Answer Posted / amedela chandra sekhar

Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the advantages of sql.

1052


Is json a nosql?

1032


How are sql commands classified?

1143


Is ms sql traffic encrypted?

960


What is exit statement?

1060


What is natural join in sql?

1044


How do you know if a relationship is 2nf?

994


What are all types of user defined functions?

1133


What is offset and limit in sql?

1103


Is sql better than excel?

1224


What is the current version of postgresql?

1127


How do you define a foreign key?

1063


How to move files from one directory to another in pl sql?

1249


what is a composite primary key ? : Sql dba

1092


How to change sql*plus system settings?

1106