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 / shilpa

Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the basic form of sql query?

943


How to place comments in pl/sql?

1158


What is a record in a database?

1062


Explain the purpose of %type and %rowtype data types?

928


Is sql a dbms?

1014


Do prepared statements prevent sql injection?

951


What is record type in pl sql?

994


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1438


Can instead of triggers be used to fire once for each statement on a view?

962


What is sql resultset?

989


How do you use a while loop in pl sql?

1013


Mention what is the use of function "module procedure" in pl/sql?

1049


The in operator may be used if you know the exact value you want to return for at least one of the columns.

1133


Can we edit a view in sql?

983


What is query execution plan in sql?

1188