We can specify a condition while using deletecommand.But Truncate is unco

What is difference between TRUNCATE & DELETE?

Question Posted / pravallika

Answer Posted / pravallika

We can specify a condition while using deletecommand.But
Truncate is unconditional

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is left join and outer join same?

1054

How do you update sql?

965

what is the difference between char_length and length? : Sql dba

1040

What is meant by cursor in sql?

987

What is the trigger in sql?

945

what is bcp? When does it used? : Sql dba

988

What packages are available to pl/sql developers?

1044

Which is the correct statement about truncate and delete?

1107

What normalization means?

968

how to use myisamchk to check or repair myisam tables? : Sql dba

968

What is trigger in pl sql with examples?

1033

What is the source code of a program?

1069

Which sql statement is used to delete data from a database?

954

What is sql partition?

1105

which operator is used in query for pattern matching? : Sql dba

1003