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 difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

2088

---

What are the advantages of database management system?

990

---

How do I keep my database up to date?

967

---

What do you understand by index hunting?

1193

---

State some commands of ddl in dbms?

1055

---

Enlist some commands of dml?

991

---

What is the best free database software?

921

---

What are the main differences between primary key and unique key?

1031

---

What is snow flake schema design in database? What's the difference between star and snow flake schema?

919

---

Which database is best for large data?

1045

---

What is concept of dbms?

959

---

How do queries work in a database?

1056

---

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

2150

---

How to reorder the table columns (fields)?

1150

---

Explain the difference between physical and logical data independence?

966

---