Answer Posted / rahul gupta

select sal from employee e1 where 5 = (select count(*) from
employee e2 where e1.sal < e2.sal)

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1042

---

What is an execution plan?

1120

---

Can a table have 2 primary keys?

968

---

Explain where clause?

977

---

Explain sub-query?

933

---

Explain the database you used in your final year project?

1019

---

What are advantages of ssrs or why we should use ssrs?

137

---

What are the types of subquery?

1024

---

What is subreport?

141

---

how to trace the traffic hitting a sql server? : Sql server database administration

1847

---

What is the dbcc command and why is it used?

1033

---

What is function of ROLLUP ?

1069

---

What is user-defined inline table-valued function?

926

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

980

---

Explain primary key in sql server?

998

---