Answer Posted / rony sunny

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 2 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Write short notes on manual refreshes.

2291

---

Explain the cube operator?

602

---

What is the database development process?

690

---

Can an extended stored procedure be called from inside a user-defined function?

610

---

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

559

---

---

Explain the process of the user request and data generating?

653

---

How to generate OIDS

1662

---

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

1658

---

Explain about network model?

587

---

How long can an error message be in raiseerror function?

550

---

Explain about xml databases?

624

---

What is a database development?

522

---

What is dbms explain in brief?

563

---

What is the maximum length of an extended property?

559

---

What are the key features of dbms?

566

---