What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

Why variables called the most powerful component of ssis?

0 Answers  

---

What is a materialized view?

3 Answers  

---

---

What is the difference between inner join and equi join?

0 Answers  

---

Explain the dirty pages?

0 Answers  

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---