Answer Posted / shanky

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

Explain the process of the user request and data generating?

658

---

How can I detect whether a given connection is blocked?

588

---

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

3443

---

How to combine two function together?

1666

---

Explain the role of indexing in databases?

645

---

---

Write short notes on manual refreshes.

2296

---

State the acid rules?

688

---

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

598

---

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

1660

---

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

1593

---

Where is dbms used?

625

---

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

580

---

Which four data types cannot be used as a return type from a user-defined function?

585

---

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?

530

---

Explain about xml databases?

626

---