Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 44923 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / rampratap singh
Truncate is DDL so it does not create rollback segments,
where as DELETE is DML and creates rollback segments.
Truncate removes/reset the high watermark.
Delete does not do that.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
How can I make sql query run faster?
What is replication id?
how to get help information from the server? : Sql dba
What will you get by the cursor attribute sql%notfound?
What is interval partition?
Define the select into statement.
Can unique keys be null?
How do I tune a sql query?
What is the process of copying data from table a to table b?
What is the use of sqldataadapter?
How do you go back in sql?
What is a primary key example?
what are the differences among rownum, rank and dense_rank? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
what are null values? : Sql dba
