Answer Posted / sowjanya

Select * from emp where sal=(select Max(sal) from emp where
sal<(select Max(Sal) from emp)

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

2147

---

What are data modelling techniques?

975

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2224

---

Explain about xml databases?

1081

---

What is an application role and explain a scenario when you would use one?

1012

---

How to use online Backups?

2207

---

Explain about relational database management systems?

971

---

What are the three types of database design?

1026

---

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

1067

---

Explain about the hierarchical model of the database?

1120

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

968

---

Who are end users in dbms?

994

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2059

---

Which data type cannot be used as a parameter in a udf?

982

---

Explain about a primary key?

991

---