Answer Posted / shrikant

I have student marks in a student table. I need all record
where second highest mark .Then what will the query for this?

What are sp_configure commands and set commands?

1075

---

What is sql server 2000 work load governor?

1158

---

Can two tables have the same primary key?

1267

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1120

---

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

1122

---

Do you know exporting and importing utility?

1105

---

Write a SQL queries on Self Join and Inner Join.

1077

---

How to drop an existing table?

1052

---

What are built in functions?

1067

---

What is Lock table in SQL?

1520

---

What are the methods used to protect against sql injection attack?

1118

---

How to convert a unicode strings to non-unicode strings?

1154

---

What do you understand by physical_only option in dbcc checkdb?

1021

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

1030

---

In how many ways you can invoke ssrs reports?

147

---