Answer Posted / vivek mohan singh

select salary from tablename order by salary desc limit 1,1;

Explain about a primary key?

928

---

How long can an error message be in raiseerror function?

937

---

How can you log an error to the server event log from a stored procedure?

1029

---

Why does this query return 0?

967

---

Explain about the database management systems.

917

---

How to use online Backups?

2149

---

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2078

---

Write short notes on manual refreshes.

2677

---

How can I detect whether a given connection is blocked?

980

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1000

---

What is dbms and its application?

942

---

Explain the rollup operator?

992

---

What is database design and development?

953

---

How to combine two function together?

2060

---

Explain about network model?

944

---