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

what is difference between delete and truncate commands? : Sql dba

Question Posted / akash yadav


what is difference between delete and truncate commands? : Sql dba..

Answer / Anamika Pandey

The DELETE command removes rows from a table, but leaves the space occupied by those rows. TRUNCATE TABLE command removes all rows from a table and also deallocates the space occupied by them.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

tell us something about heap tables. : Sql dba

1 Answers  

What is string join?

1 Answers  

what is foreign key? : Sql dba

1 Answers  

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

Define concurrency control. : Transact sql

1 Answers  

What is normalisation in sql?

1 Answers  

What is the maximum rows in csv?

1 Answers  

How do you sort in sql?

1 Answers  

Are stored procedures compiled?

1 Answers  

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1 Answers  

Explain the uses of a database trigger?

1 Answers  

Is postgresql a nosql database?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories