Truncate will remove the watermark from the table, but the delete will no

What is the difference between DELETE and TRUNCATE?

Question Posted / gourvendra singh

Answer Posted / gourvendra singh

Truncate will remove the watermark from the table, but the
delete will not.

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between drop and truncate commands?

1045

Which are sql * plus commands?

1106

how can you create an empty table from an existing table? : Sql dba

1133

How to convert comma separated string to array in pl/sql?

1164

how to increment dates by 1 in mysql? : Sql dba

959

Who developed sql?

1018

Explain the uses of a database trigger?

1016

Can we join more than 2 tables in sql?

1000

What are different types of queries in sql?

1102

What are pl/sql cursor exceptions?

1074

what does the t-sql command ident_incr does? : Transact sql

1054

What is sql integrity?

1131

What is transaction control language (tcl)?

1115

What is the use of index in hive?

988

Is inner join faster than left join?

1171