Answer Posted / balindra sahani

select max(sal) from emp
where sal not in (select max(sal) from emp )

How to replace not in with not exist?

1978

---

Explain about the hierarchical model of the database?

1056

---

What are the types of database model?

1025

---

What is database design and development?

953

---

How can I detect whether a given connection is blocked?

980

---

What is dbms explain in brief?

954

---

What is normalization? Explain different levels of normalization?

62697

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1968

---

Explain about query and reporting.

2026

---

What is dbms and its application?

942

---

How can you fix a poorly performing query?

1103

---

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

2077

---

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

---

Explain the role of indexing in databases?

1066

---

Explain the rollup operator?

991

---