Answer Posted / vinay upadhyay

These are tested queries to find Nth highest salary

Select distinct(sal) From employee emp Where n =
( Select Count(Distinct y.sal) From employee y Where y.sal
>=emp.sal)

OR

select distinct(salary) from employee order by salary desc
limit n-1,1

What do you understand by recursive stored procedures?

955

---

explain different types of constraints? : Sql server database administration

929

---

Is it important for a database administrator to understand the operating system and file access?

943

---

What the class forname () does?

1001

---

What do you understand by physical_only option in dbcc checkdb?

956

---

What is the use of stored procedure?

910

---

What is blocking?

1008

---

Can group functions be used in the order by clause in ms sql server?

977

---

Explain what is meant by replication of database?

973

---

Do you know what is a trace frag? Where do we use it?

967

---

How many primary keys are possible in a table?

891

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

995

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1035

---

List out the difference between union and union all in sql server?

942

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1165

---