Explain primary key, foreign key and unique key?

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

What factors you will consider calculating the storage requirement for that view?

0 Answers  

---

What is data compression? : sql server database administration

0 Answers  

---

---

What is xml datatype?

0 Answers  

---

Do you know concepts and capabilities of sql server?

0 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

How do you know which index a table is using?

4 Answers  

---

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---