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.

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

2057

---

What does specialization in DBMS mean?

1164

---

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1983

---

give a simple example of physical and logical data independence

2567

---

What is a super key?

1044

---

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

2554

---

What is difference between server and database?

1095

---

What is the difference between primary key, foreign key and candidate key?

1112

---

Explain data independence & its types.

1053

---

1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

2197

---

aht is the difference b/w network & hierarchial & relational dbms????

2217

---

What is the importance of database partitioning?

1062

---

What will happen non-clustered index will be created on clustered index?

1047

---

sparse lookup and where its options we find in OCI and db2?

2224

---

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

2065

---