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.

What does <> mean in database?

0 Answers  

---

What are the two main functions of queries in databases?

0 Answers  

---

What are the ways to tune reporting services?

0 Answers  

---

Explain fully functional dependency?

0 Answers  

---

Explain the functionality of dml compiler.

0 Answers  

---

---

How do you handle your own transaction?

0 Answers  

---

i need query for displaying the eno,ename in a table from row 2 to row 5

1 Answers  

---

how to solve cardinality in dbms...many to many ralationships

0 Answers  

---

What is create database?

0 Answers  

---

Why does reading require write privileges on database file?

0 Answers  

---

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

1 Answers  

---

Define denormalization.

0 Answers  

---