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 dialect in database?

929

---

What are database connection details?

1080

---

issues involved in modeling and building data werahouses

1905

---

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

1053

---

There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

2115

---

Is hive a database?

896

---

What is the relationship that exists inside in E-R diagram?

1040

---

What is a database string?

892

---

What are the advantages of using database?

975

---

What is database server and how it works?

976

---

A design problem was given in which I was supposed to make a design for the data base for a given problem.

1011

---

Can a database table exist without a primary key?

888

---

What is difference between server and database?

1019

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1500

---

How default key is different from primary key?

986

---