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 Database Management System?

1114

---

How is a database related to a table?

925

---

What are the disadvantages of file processing systems?

978

---

What is advantage of dbms?

975

---

What are the steps to follow when preparing to create a table?

848

---

What are the types of rdbms?

864

---

Explain the syntax of named procedure?

943

---

Does google have a database like access?

918

---

What is database management system(dbms)?

960

---

What do you understand by data redundancy?

876

---

Explain the classification of Database Management System?

4164

---

Why do not you use gnu autoconf or scons for building?

898

---

Explain the importance of partitioning.

929

---

What versions of clipper does netlib support?

957

---

Which is the most used database?

887

---