What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

Explain different types of index?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

State the difference between union and union all?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

What is 1nf normalization form?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What is Transaction?

2 Answers  

---

How to get the query of a table in sql server?

0 Answers  

---