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 Drop and Truncate

Answer Posted / mohsin mohammed abdul

Drop means removing the existing object from the database.
turncate means you are deleting the data from the table and
oracle implicitly issues commit statment and even when you
say rollback , you won't get the data back due to commit ..

Is This Answer Correct ?    36 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Ms sql server index?

1050


Do you know what is normalization of database? What are its benefits?

1096


Mention the differences between sql server and mysql.

1001


How to transfer a table from one schema to another?

985


How to include date and time values in sql statements?

1074


What does ss stand for sexually?

1068


Explain the properties of the relational tables?

980


What is collation?

1128


Do you know exporting and importing utility?

1023


Is null in sql server?

971


What is deploy, process and build? : sql server analysis services, ssas

1089


Some queries related to SQL

964


Can we install sql server 2016 on windows 7?

1116


What do you mean by an execution plan? How would you view it?

906


how can a database be repaired? : Sql server administration

957