Answer Posted / shivaleela

DELETE:-

1.it is a DML stmt
2.it can include WHERE condition
3.it is only delete, so it can be rolled back can be ROLL
BACK

TRUNCATE:-

1.it is a DDL stmt
2.it can not include WHERE cnd
3.it is delete+commit ,so we cant roll back can not be ROLL
BACK


Both commands accomplish identical tasks (removing all data
from a table), but TRUNCATE is much faster

Reason:When you type DELETE.all the data get copied into
the Rollback Tablespace first.then delete operation get
performed.Thatswhy when you type ROLLBACK after deleting a
table ,you can get back the data(The system get it for you
from the Rollback Tablespace).All this process take
time.But when you type TRUNCATE,it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster.Once you Truncate you cann't get back
the data.

What is the Lock Based Protocol used for?

819

---

What is database schema name?

750

---

What is the use of graph database?

733

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2281

---

What is the Difference Primary key and Unique Key

753

---

What is difference between clustered, non-clustered and unique index?

799

---

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2342

---

What is ole db ado?

722

---

Explain natural key?

802

---

What is the purpose of firebase?

724

---

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1833

---

What is a reference table in database?

738

---

if i want to display the name of students such that to which city they belong must have count greaer than two

1964

---

What is the best database?

709

---

What is the role of driver manager?

749

---