Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 45839 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
Does sql backup shrink transaction log?
what is meant by nl2br()? : Sql dba
What is normalization? How many normalization forms are there?
What is coalesce sql?
What is basic structure of pl sql?
What are sql procedures?
How do you rename a table in sql?
is it possible to pass an object or table to a procedure as an argument?
Explain commit, rollback and savepoint.
What are data types in pl sql?
How to check if a column is nullable before setting to nullable?
Define SQL and state the differences between SQL and other conventional programming Languages?
What are few of the schema objects that are created using PL/SQL?
What is lookup table in sql?
What is data types in sql?
