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

what is the difference between clustered and non clustered index in sql? : Sql dba

1182

What is the difference between the sql*loader and import utilities? : aql loader

1086

what are the disadvantages of mysql? : Sql dba

1201

What are schema-level triggers?

1148

What is lexical units in pl sql?

1201

what is schema? : Sql dba

1099

Is pl sql better than sql?

1084

Explain the difference in execution of triggers and stored procedures?

1059

What is primary key in db?

1066

How many primary keys can a table have?

1052

How can you create an empty table from an existing table?

1123

What are the events on which a database trigger can be based?

1235

What are the ways on commenting in a pl/sql code?

1200

What is sql procedures and functions?

1070

Can we call a function containing dml statements in a select query?

1021