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

Is sql free?

884

What are variables in pl sql?

1090

What are the 3 types of behavioral triggers?

1181

Explain mutating table error.

1129

How do I view tables in sql developer?

881

What is the source code of a program?

1001

How is use pl and sql?

1000

What is a database trigger?

1016

how to shutdown mysql server? : Sql dba

1027

What is a dirty read sql?

1029

In a distributed database system, can we execute two queries simultaneously?

990

Cite the differences between execution of triggers and stored procedures?

1026

What is a scalar value in sql?

1010

How to combine two stored procedures in sql?

1118

What is sql engine in oracle?

924