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

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'.

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;

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.

Which is fastest database?

0 Answers  

---

What is database in simple language?

0 Answers  

---

If I use netlib, will I find many other users to network with?

0 Answers  

---

Mention some disadvantages of query?

0 Answers  

---

If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  

---

---

When is a .FMB file extension is created in Forms 4.5 ?

1 Answers  

---

What do you mean by Correlated subquery in database?

0 Answers   B-Ways TecnoSoft,

---

What are the different stages in 'data warehousing'?

0 Answers  

---

What's the difference between delete and truncate ?

0 Answers  

---

What's the best database software for mac?

0 Answers  

---

Define normalization.

0 Answers  

---

What is the use of CONSTRAINTS option in EXP command ?

1 Answers  

---