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

Explain polymorphism in pl/sql.

1056

Do we need to rebuild index after truncate?

973

What is the purpose of my sql?

900

What is data modelling in sql?

962

Can ddl statements be used in pl/sql?

1068

what are all the different normalizations? : Sql dba

960

Is sql a case sensitive language?

891

How do I view a table in sql?

947

how to include numeric values in sql statements? : Sql dba

1039

How to take user input in pl sql?

1106

What is clustered index sql?

930

what is a unique key ? : Sql dba

1025

How do I install microsoft sql?

981

What is plpgsql language?

977

How subquery works in sql?

994