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

Explain autonomous transaction.

1162


How can we optimize a sql query?

1054


What is graph sql?

996


How to place comments in pl/sql?

1169


What is vector point function?

1057


What is thread join () in threading?

1019


How do you clear the screen in sql?

1077


What is a primary key called that is made up of more than one field?

1354


What does (*) mean in sql?

955


Is sql scripting language?

1058


Can a key be both primary and foreign?

1002


what are date and time data types? : Sql dba

991


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2576


What is a column in a table?

1130


I need a function for a train ticket reservation please answer it thanks in advance

1033