What is the difference between DELETE and TRUNCATE?
Answer Posted / babloo
when truncate command is issued, all the rows from the
table are deleted and the memory space occupied by the
table in the tablespace is also released whereas when
delete command is issued, only all the rows are deleted
fronm the table
| Is This Answer Correct ? | 28 Yes | 0 No |
Post New Answer View All Answers
How can use stored procedures in sql?
What do you mean by stored procedures? How do we use it?
Write a unique difference between a function and a stored procedure.
What is sql key?
Why is %isopen always false for an implicit cursor?
What is scalar function in sql?
What is the need of a partition key?
Define select, insert, create, delete, update, drop keywords
What is sql query optimization?
What is the difference between a procedure and a function?
What is the difference between stored procedure and view?
how to concatenate two character strings? : Sql dba
which operator is used in query for pattern matching? : Sql dba
What is dml statement?
What is sql injection owasp?