Answer Posted / praveen singh

select min(salary) from salary where salary in(select top 3
salary from salary order by salary desc)

Where is my database stored on the hard disk in ms sql server?

1000

---

Explain how many normalization forms?

970

---

Tell me in brief how sql server enhances scalability of the database system?

941

---

Explain timestamp datatype?

913

---

What is executereader?

898

---

Does full backup break log chain?

913

---

What is unique key constraint?

989

---

Explain can you implement data mining in ssrs?

145

---

What are the fixed server level roles? : sql server security

1054

---

What is difference between equi join and inner join?

860

---

when would you go for denormalization? : Sql server database administration

813

---

What are the mathematical functions supported by sql server 2005?

998

---

How many non clustered indexes there can be on table ?

863

---

What are temporal tables in sql server 2016?

841

---

What are filegroups in sql server?

1014

---