Answer Posted / 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

What is the purpose of queries in a database?

998

---

What is dbms architecture?

981

---

What is network database?

972

---

Who is end user in database?

808

---

Which database server is best?

987

---

What is e-r model in the dbms?

989

---

How to handle data if f table are more than one and each table contain thousands of entries?

2003

---

What is data redundancy in dbms?

852

---

What are the differences between a dbms and rdbms?

906

---

Is the internet a database?

890

---

What are new features postgre 9.1?

924

---

Is it good to save image in database?

950

---

Why do I need netlib?

933

---

Mention how deadlock can be resolved?

912

---

What is the purpose of sql?

878

---