Answer Posted / saurabh

select max(salary) from Employee where salary not in (
select top 5 Salary from ( select distinct Salary from
Employee order by Salary desc))

What do you mean by an execution plan?

779

---

What is difference between clustered and non clustered index?

704

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

698

---

What are types of subqueries?

749

---

What are the five major components of a dbms?

670

---

Define constraints and give an example of their use?

745

---

Why truncate is ddl?

821

---

State the difference between union and union all?

693

---

What is always encrypted?

697

---

How to list all login names on the ms sql server?

706

---

What is triggers in ms sql server?

810

---

Which language is supported by sql server?

707

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

767

---

Explain activity monitors

806

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

789

---