What is the difference between DELETE and TRUNCATE?
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