Answer Posted / shashank tayal

select salary from table_name order by desc limit 3,1;

What happens if you add a new index to large table?

931

---

Describe the left outer join & right outer join. : sql server database administration

992

---

can you implement data mining in SSRS?

148

---

What kind of problems occurs if we do not implement proper locking strategy?

1395

---

How to fine-tune reports?

266

---

How to use user defined functions in expressions?

1082

---

Explain time data type in sal server 2008?

918

---

How to update muliple row in single query?

1052

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

945

---

How efficient you are in oracle and SQL server?

1146

---

Give me a SQL Query to find out the second largest company?

1161

---

How to enter unicode character string literals in ms sql server?

1066

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1137

---

Explain what is dbcc?

1002

---

State a few properties of relational databases?

1120

---