Answer Posted / nishant dubey

Table join itself using alias..
example
Select N,emp_id,N.emp_name,D.emp_id,D.emp_name from Nishant
N,Nishant D where N.emp_id=D.emp_id;

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

1056

---

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

2182

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1050

---

Explain about network model?

1047

---

Explain about the storage and physical database design?

968

---

What is DB Development software?

2115

---

Explain about xml databases?

1113

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1071

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2468

---

What is normalization? Explain different levels of normalization?

63395

---

Explain about the hierarchical model of the database?

1165

---

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

1110

---

Write the fastest query to find out how many rows exist in a table?

1169

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2208

---

How can you fix a poorly performing query?

1253

---