truncate: --------- truncate is a ddl command. ddl commands having auto

What is difference between TRUNCATE & DELETE?

Question Posted / suneel

16 Answers
45736 Views
Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
E-Mail Answers

Answer Posted / suneel

truncate:
---------
truncate is a ddl command.
ddl commands having auto commit.

delete:
-------
delete is a dml command.
dml commands not having auto commit.

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you take the union of two tables in sql?

981

What are packages in pl sql and also explain its advantages?

1032

What is difference between procedure and trigger?

976

Is primary key an index?

989

What is pivot table in sql?

1103

Explain unique key in sql.

1006

What are variables in pl sql?

1161

How to return an array from java to pl/sql?

1132

How many rows can sqlite handle?

1110

How does sql store data?

902

What is the purpose of cursors in pl/sql?

1134

What is denormalization in a database?

1051

How do you update a sql procedure?

1024

how to delete an existing column in a table? : Sql dba

1005

explain the advantages and disadvantages of stored procedure? : Sql dba

1007