Delete - temparaly delete the table we can undo it using rollback where

What is Difference Between delete and Truncate?

Question Posted / muralipitti

Answer Posted / muralipitti

Delete - temparaly delete the table we can undo it using
rollback where as

truncate= delete+commit we can't rollback it .

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a natural join?

1140

How can I see all tables in sql?

1142

What is trigger in sql? Explain

1043

Why do we need view in sql?

1037

Can we use two order by clause in query?

1015

How can the performance of a trigger be improved?

1087

How do you update sql?

1036

Can variables be used in sql statements?

1073

What is the difference between inner join and natural join?

1055

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1008

What is informix sql?

1029

What is pl sql in oracle?

1095

How many types of literals are available in pl sql?

1166

What are the different sql commands?

1126

differentiate between float and double. : Sql dba

1110