Answer Posted / anuj somvanshi

select salary from emp where rownum=n order by salary desc;

what is hash nonclustered index

1023

---

what data regions are and what are the different data regions?

146

---

Why does sql studio use a single registered database repository? : sql server management studio

1041

---

Explain what are sparse columns?

1070

---

Disadvantages of the indexes?

1185

---

How to create “dependant” parameter “make, model, year”

137

---

Explain about sql server login?

1139

---

Explain boyce and codd normal form(bcnf)?

1016

---

How to write a query with an inner join in ms sql server?

1096

---

What is SQL Azure Firewall?

136

---

How to assign null values to variables or columns?

1030

---

How much does sql server 2016 cost?

1160

---

Explain what is dbcc?

1068

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

997

---

What is difference between primary key and foreign key?

953

---