Truncate is DDL so it does not create rollback segments, where as DELETE

What is difference between TRUNCATE & DELETE?

Question Posted / rampratap singh

16 Answers
46338 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

Please Help Members By Posting Answers For Below Questions

Mention what does plv msg allows you to do?

1157

What are primary key and foreign key and how they work?

1015

What is sql partition?

1158

Can you select everything, but 1 or 2 fields, without writer's cramp?

1035

Explain what is sql*plus?

1192

What is materialized view in sql?

952

What is dba in sql? : SQL DBA

1087

How can we optimize a sql query?

1104

What is trigger with example?

1160

What is set transaction?

1084

Is sql a scripting language?

1080

how can we know the count/number of elements of an array? : Sql dba

1104

Which sql statement is used to return only different values?

1051

Explain the types of joins in sql?

1070

How do I trace sql profiler?

1039