Answer Posted / k.elumalai

select max(salary)from emp where salary <(select sum(salary)
from emp)

Name and describe few console utilities for ssrs?

249

---

What is exclusive locks?

533

---

What is etl - extraction, transformation, and loading?

520

---

Explain the different types of backups available in sql server? : sql server database administration

512

---

How to list all columns in a table using odbc_columns()?

531

---

---

What is the difference between insensitive and scroll cursor?

576

---

Explain user defined views?

569

---

what are acid properties? : Sql server database administration

486

---

What is resource governor in sql server?

542

---

What is a cube? : sql server analysis services, ssas

557

---

What do you mean by sql server agent?

533

---

How many non clustered indexes there can be on table ?

505

---

Define master database?

574

---

Explain primary key in sql server?

562

---

Distinguish between commit and rollback?

538

---