Answer Posted / divya

candidate key: is a column in a table which has thhe ability
to become a primary key.

alternate key:any of the candidate key that is not part of
the primary key.

Explain the role of indexing in databases?

1187

---

Explain about the storage and physical database design?

968

---

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?

2470

---

What is the physical representation for a many-to-many relationship?

1135

---

What are the 18 schemas?

1189

---

How you can make a parameterized view?

1069

---

Explain about post-relational databases?

1078

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4053

---

How is data stored in dbms?

1008

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

1056

---

Explain about relational operator join?

1095

---

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

2184

---

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

1020

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1020

---

Explain about normal forms?

1106

---