we can go upto some number of records through delete while in truncate we

What is the difference between DELETE and TRUNCATE?

Question Posted / sanjay keserwani

Answer Posted / sanjay keserwani

we can go upto some number of records through delete while
in truncate we have to unoccupied all records.

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Is primary key always clustered index?

1024

Can I join the same table twice?

1049

What is numeric function sql?

1066

What is asqueryable?

977

What is execute immediate?

1088

How do I run a pl sql procedure in sql developer?

974

Are left and right joins the same?

1088

How do I copy a table in sql?

993

What is record variable?

997

What is a join query?

969

List different type of expressions with the example.

935

What is pivot table in sql?

1115

Why do we use sqlite?

985

What has stored procedures in sql and how we can use it?

1083

How to take user input in pl sql?

1167