Truncate is a DDL command and hence cant be rolled back where as delete is

What is difference between TRUNCATE & DELETE?

Question Posted / deva

Answer Posted / deva

Truncate is a DDL command and hence cant be rolled back
where as delete is DML command and thus can be rolled back
if not necessary.

Is This Answer Correct ?

31 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the various levels of constraints?

1167

Can 2 queries be executed simultaneously in a distributed database system?

1190

How can we optimize a sql query?

1107

how to return query output in html format? : Sql dba

1120

What is a database? Explain

1176

Can two tables have same primary key?

1022

Does sql between include endpoints?

1059

Is truncate ddl or dml?

1037

Can we change the table name in sql?

1000

what is cross join? : Sql dba

1046

What is pl sql collection?

1014

what is query cache in mysql? : Sql dba

1077

What are the types pl/sql code blocks?

1192

What are the qualities of 2nf?

1094

How would you convert date into julian date format?

1041