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 benefit of database?

892

---

what are the differences between an exclusive lock and a shared lock?

990

---

What is Data Redundancy and Consistency ?

1001

---

Explain meant by 3-tier architecture?

947

---

What are database functions?

889

---

What is openedge workgroup rdbms?

1012

---

What are cursors and what are the situations you will use them?

968

---

What is difference between database and website?

1062

---

What are the three main types of models?

899

---

dear sir please provide what question will be asked in CWE in bank it officer

2240

---

How to improve query performance using index hunting?

1174

---

Segregate database technology's development.

1556

---

What is view dbms?

919

---

How do you create a simple database?

987

---

What are the various normalizations in database?

994

---