Answer Posted / guest

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

How to combine two function together?

2124

---

What is normalization? Explain different levels of normalization?

63104

---

Explain about normal forms?

1054

---

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

2142

---

Explain the cube operator?

1005

---

What are the key features of dbms?

991

---

How to use timestamp datatypes

2035

---

How can you log an error to the server event log from a stored procedure?

1104

---

What are the three basic rules which are to be followed for the relational model of the database?

1013

---

How to customize error conditions.

2148

---

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

2023

---

How to read and create .LDC data files which are used by linguatic dictionary.

2529

---

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

1115

---

Explain about network model?

1002

---

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

1009

---