1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Why use truncate instead of delete?

Question Posted / vivek bhagat


Why use truncate instead of delete?..

Answer / Somil Gupta

Truncate deletes all records in a table and reclaims storage space, while delete just removes the records but does not immediately free up space.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What can you do with pl sql?

1 Answers  

Is sql port 1433 encrypted?

1 Answers  

What is output spooling in sql*plus?

1 Answers  

What is sql performance tuning?

1 Answers  

What is a null value?

1 Answers  

Is keyword pl sql?

1 Answers  

Is oracle sql free?

1 Answers  

What is multiple columns?

1 Answers  

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1 Answers  

difference between pl/sql table and normal pl/sql table

2 Answers  

Explain character-manipulation functions?

1 Answers  

Does pl sql work in mysql?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories