What is user defined datatypes and when you should go for them?

1014

---

What is normalization? Explain different forms of normalization?

1156

---

Explain candidate key, alternate key, and composite key?

1003

---

Please explain go command in sql server?

1051

---

Tell me what is log shipping?

977

---

Do you know what is lock escalation?

1011

---

What are the different index configurations a table can have?

960

---

Explain difference between cross join and full outer join?

1005

---

What is the stuff and how does it differ from the replace function?

1130

---

Explain what is use of dbcc commands?

1057

---

Explain what is raid and what are different types of raid levels?

1024

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

961

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

942

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

975

---

Explain what are commit and rollback in sql?

931

---