what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 Answers  

---

what is semphore explian it?

0 Answers   IBM,

---

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

---

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

i have marks in table,how to find total?

1 Answers  

---

When the procedures or packagess become invalidate

3 Answers   TCS,

---

Name two files used for network connection to a database.

1 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

For web applications from which version of Oracle is suitable?

1 Answers  

---

What is the difference between oracle media recovery and crash recovery?

0 Answers  

---