what is the difference between delete and truncate?

Question Posted / rukumanikhandhan

4 Answers
5936 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between delete and truncate?..

Answer / kadambari

Difference between Delete and Truncate :-

1. Truncate is a DDL statement hence it implicitly commits;
Delete is a DML statement hence we have to manually perform
commit.

2. Truncate doesn't fire the delete trigger hence it is
faster than Delete operation.

3. Once Truncated, data cannot be roll-backed; Delete
operation can be roll-backed.

4. Truncate resets the High water mark and frees up all the
extents; Delete doesn't reset the High water mark.

Thanks

Is This Answer Correct ?

13 Yes

0 No

what is the difference between delete and truncate?..

Answer / nithya

The basic difference between delete and truncate is 'high
water mark'. High water mark indicates the max level to
which the data has risen in the table.

Deleting a table removes only the data from it whereas

Truncating a table removes all the data from the table and
resets the relevant pointers including 'high water mark'.

Is This Answer Correct ?

5 Yes

0 No

what is the difference between delete and truncate?..

Answer / venkatesh kumar.s

Truncate:The truncate command deletes the rows in the
table,but not the structure of the table.
Cmd-truncate table tablename;
Drop:The drop command will drop the table from the databases.
Cmd-drop table tablename;
Delete:The delete cmd removes tuples from a relation.It
includes where clause to select the tuples to be deleted.
Cmd-delete from tablenmae where attribute-name="value" or value;

Is This Answer Correct ?

3 Yes

0 No

what is the difference between delete and truncate?..

Answer / kumarsunny9

Truncate is more faster than delete.

in sql you need to write statement: truncate table

table_name

truncate delete all record from table.it remain only

structure of table.

Is This Answer Correct ?

1 Yes

7 No

Post New Answer

More Database Management Interview Questions

What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

0 Answers

What is a database report?

0 Answers

What is index hunting?

0 Answers

What SYSTEM VARIABLE is used to refer DATABASE TIME ?