Answer Posted / dinesh sharma

select User_Id()

What are the 18 schemas?

1192

---

How can I detect whether a given connection is blocked?

1120

---

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

1056

---

What is normalization? Explain different levels of normalization?

63419

---

How to use timestamp datatypes

2079

---

What is data modeling with example?

1059

---

What are the three types of database design?

1085

---

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

2588

---

Explain what a database is?

1085

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2902

---

Who are naive users?

1048

---

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

2187

---

What are the key features of dbms?

1046

---

Explain about the hierarchical model of the database?

1168

---

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

1063

---