Answer Posted / shanky

Triggers are PL/SQL blocks which are executed implicitly
based
on database events.

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

4008

---

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

2144

---

Explain about relational database management systems?

966

---

Who are end users in dbms?

990

---

What are the 18 schemas?

1121

---

Explain the rollup operator?

1076

---

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

1002

---

How to use timestamp datatypes

2039

---

How to replace not in with not exist?

2089

---

Explain about the database management systems.

970

---

How can you fix a poorly performing query?

1183

---

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).

2215

---

How would you design a database for an online site, which would average a million hits a day?

1012

---

Explain about a primary key?

983

---

explain detail about ftp in datastage?

2244

---