Answer / Deepika Raj

A Unique Index ensures that every key in the indexed column(s) is unique. The values are required to be unique within the table, but not necessarily null.

what is maximum size of temp db?

4 Answers   iSoft,

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

Does sql server 2000 clustering support load balancing?

1 Answers  

---

What are key constraints?

1 Answers  

---

Define constraints and give an example of their use?

1 Answers  

---

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

---

What is the difference between composite index and covering index?

1 Answers  

---

What is explicit mode in sql server?

1 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

What is multilevel indexing?

1 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 Answers  

---

What do you mean by an execution plan?

1 Answers  

---