Answer Posted / dhivya

Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join

fact table and dimension table containg one to many relationship or many to one relastionship

2503

---

State the acid rules?

1140

---

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?

2437

---

Write short notes on manual refreshes.

2747

---

Why does this query return 0?

1023

---

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

2151

---

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

1116

---

Explain the role of indexing in databases?

1141

---

Where is dbms used?

1090

---

What are the key features of dbms?

1004

---

Explain the rollup operator?

1086

---

What is dbms explain in brief?

1041

---

What is DB Development software?

2082

---

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

2861

---

What are the constraints on severity level in raiseerror?

1000

---